Fun with COUNT and AND functions.
Try this:
=SUMPRODUCT(--(B1:B20=4),--(C1:C20="toronto"))
Adjust your range as needed.
HTH,
Paul
--
"Johosh" wrote in message
...
Okay... i'm trying to count the amount of times 2 different values appear
in
a row.
ie basically, how many rows the number '4' occurs in column 'b' and
'toronto' occurs is column 'c'.
it can only count rows where both cases are true.
I just can't make it work.
lil help?
|