COUNTIFS
 

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.

COUNTIFS
 

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.

COUNTIFS
 

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

COUNTIFS
 

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.

--
Biff
Microsoft Excel MVP


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