How do I count sets of cells in two columns?
Try this:
=SUMPRODUCT(--(A1:A5="a"),--(B1:B5=4))
--
Biff
Microsoft Excel MVP
"David" wrote in message
...
1 2
a 4
b 2
a 4
c 3
b 4
For the above example, I would like a formula that can count how many
times
"a" appears in column 1 with "4" in column 2 of the same row. The output
for
this example should be 2
|