Try this:

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

--
Biff
Microsoft Excel MVP


"Skinman" wrote in message
...
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.