COUNTIFS

S

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.
 
S

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top