COUNTIFS

[Skinman]

In need of assistance please.
I use this formula in 2007
=COUNTIFS(C6:C13,C6,A6:A13,A6)
In A column are dates, C column numbers. I do a count on Column C if they
fall on the same date
in Column A
I need to change this formula to "xls 2003" compatibility to send to
colleagues.
When I go to menu Prepare -- compatibility check, tells me not compatible
with
xls. 2003.
Can't manage to construct a formula to do the same task
Thanks.

 

[T. Valko]

Try this:

=SUMPRODUCT(--(A6:A13<>""),--(A6:A13=A6),--(C6:C13<>""),--(C6:C13=C6))

 

[Skinman]

Works. Thanks very much Biff. (knew it would!)
A month of Sundays and I still wouldn't have figured that out!
What a large formula replacement.
Much appreciated.

 

[T. Valko]

What a large formula replacement.

Yeah, you may not need the --(range<>"") arrays but I put them in there to
*exactly* match the way COUNTIFS works.