Hi
do you mean
=SUMPRODUCT(--(A1:A100<""),--(B1:B100="yes"))

--
Regards
Frank Kabel
Frankfurt, Germany
"Spencer Hutton" <Spencer schrieb im
Newsbeitrag ...
Is there a way to get countif to calculate this expresion.
"Count the number of cells in column A, if the corresponding cell in
column
B equals yes"
TIA