There are always a half a dozen different ways of doing the same thing.
Which way is best, like beauty, is in many cases only in the eye of the
beholder.
I was not implying that your way was inferior. I know the person didn't try
my formula. But, no matter.

Regards,

Tyro

"PCLIVE" wrote in message
...
I wasn't saying that one way is better than another. I was simply trying
to point out that had they tried your formula, they would have seen that it
is just another way to write a SUMPRODUCT formula to achieve the same
result. But I guess they didn't trying it before shooting it down.

Regards,
Paul

--

"Tyro" wrote in message
...
:) I prefer my way because I'm a programmer and instead of using "--"
twice, I use "*" once. To each his own.

Regards,

Tyro

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