R
rmclafferty1
My Countifs seems to work as long as I do not sort.
For example, I want to sort by date rather than name:
• Bob Smith that was on line 12 is now is on line 148.
• In the Countifs formula Criteria 2 it is referencing cell C12 and
returning Jane Doe’s information from the other worksheets.
I have tried anchoring and not anchoring the reference cell prior to sorting
(i.e., C12 or $C12) or $C$12 which returns 0 for everyone.
For example, I want to sort by date rather than name:
• Bob Smith that was on line 12 is now is on line 148.
• In the Countifs formula Criteria 2 it is referencing cell C12 and
returning Jane Doe’s information from the other worksheets.
I have tried anchoring and not anchoring the reference cell prior to sorting
(i.e., C12 or $C12) or $C$12 which returns 0 for everyone.