countif refering to 2 cells at the same time

T

toby

if i hv 2 columns of data ,
1 2
f date
... ..

i know how to count the no. of "f" in column 1, but wht
should i do if i want to count the no. of cells hving "f"
& "date" correspondingly?
thanks
 
T

Toby

Sorry,
i've tried ur method. but it seems dont work!
is there any problem of it?!!?
value## was shown in the cell.
 
E

EdgeOfCity

methord of array formula input:::
enter:
=sum((A1:a10="f")*(b1:b10="date"))
and then press ctrl+shift+enter after that.
my english is not so good.hope you'll catch it.

"Toby" <[email protected]> дÈëÓʼþ
Sorry,
i've tried ur method. but it seems dont work!
is there any problem of it?!!?
value## was shown in the cell.
 
D

Don Guillett

Probably meant SUMproduct instead of product
No need to array enter.

--
Don Guillett
SalesAid Software
[email protected]
A better method would be to use:
=product((A1:a10="f")*(b1:b10="date"))
 
Top