countif refering to 2 cells at the same time

  • Thread starter Thread starter toby
  • Start date Start date
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
 
Sorry,
i've tried ur method. but it seems dont work!
is there any problem of it?!!?
value## was shown in the cell.
 
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.
 
Probably meant SUMproduct instead of product
No need to array enter.

--
Don Guillett
SalesAid Software
(e-mail address removed)
A better method would be to use:
=product((A1:a10="f")*(b1:b10="date"))
 
Back
Top