I haven't quite figured out any usefulness to the new COUNTIFS function yet.
It doesn't work the way you'd think. If all 3 conditions were met in a
particular spot in the array, then it would count 1. So, if your data looked
like:

15 51 30

15 30 18
51 15 18
30 51 30

Then it would return a value of 1, since A3, A4, and A5 all met their
respective criteria.

I've gotten used to using SUMPRODUCT for this type of problem, so haven't
really seen much need for these new functions.

=SUMPRODUCT((A3:C3=A1)+(A4:C4=B1)+(A5:C5=C1))

HTH,
Elkar


"Jim" wrote:

Has anyone experienced any substantial errors from the Countifs Formula?

A B C
1 15 51 30

3 20 30 18
4 20 15 18
5 15 51 30


COUNTIFS(A3:C3,A1,A4:C4, B1,A5:C5, C1) = 0 when it should equal 1

Is my syntax wrong? This what the formula produces?

Any ideas?