Try a formula like

=SUMPRODUCT(--(A1:A5=1),--(B1:B5=1),--(C1:C5=3))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"dlund" wrote in message
...
what if you have 3 columns to check?

with an array like

1 1 3
2 1 2
2 1 4
1 2 3
1 1 3

How do you count the number of "1 1 3" occurances?