Prev: Delete rows data moving
Next: Matching two groups of data within one sheet
From: rmclafferty1 on 17 May 2010 09:44
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.

From: Luke M on 17 May 2010 09:55
If you want to do a CountIf by Bob everytime, instead of by what's in cell
12, why not replace the cell reference w/ "Bob Smith"?

The other option would be to create a static list that is not getting
sorted, and base the COUNTIFs off of that list.

--
Best Regards,

Luke M
"rmclafferty1" <rmclafferty1(a)discussions.microsoft.com> wrote in message
news:CF07BAEA-188A-4675-9A12-E759D407E995(a)microsoft.com...
> 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.
>


 | 
Pages: 1
Prev: Delete rows data moving
Next: Matching two groups of data within one sheet