Thanks for the feedback. Just as an FYI, I don't know if you tried Tyro's
formula =SUMPRODUCT((A2:A300=F12)*(C2:C300=F17))

but that is actually just a slightly different way to write the SUMPRODUCT
formula in order to achieve the same result. I personally prefer the way I
did it because I think it's cleaner and easy to read.

=SUMPRODUCT(--(A2:A300=F12),--(C2:C300=F17))

Thanks again for the feedback.
Paul


--

"HenderH" wrote in message
...
Brilliant "PCLIVE" a) You spec my problem exactly b) your solution
worked!!

Thank you.

Kind Regards


"PCLIVE" wrote:

Maybe this:

=SUMPRODUCT(--(A2:A300=F12),--(C2:C300=F17))

If I understand you correctly, this formula will count how many times
these
two conditions are met within rows 2:300. Column A must match criteria
F12
and Column C must match criteria F17. Correct?

HTH,
Paul


--

"HenderH" wrote in message
...
I have got a working spreadsheet in 2007 and I want to give a copy to a
colleague.

The problem is that he he still uses 2003

How do I get 2003 to do this "=COUNTIFS(A2:A300,F12,C2:C300,F17)"