COUNTIF
 

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

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

Wouldn't that be the same count of the number of cells in B that are Yes?

=countif(b:b,"yes")



Spencer Hutton wrote:

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

--

Dave Peterson

Why can't you just use

=COUNTIF(B:B,"yes")

I mean unless you have a condition that needs to be met in A the above
should be enough, if
there is a condition in A as well you can use

=SUMPRODUCT(--(A1:A200="condition1"),--(B1:B200="yes"))


--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Spencer Hutton" <Spencer wrote in message
...
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

If there is nothing that must holds for column A itself...

=COUNTIF(B:B,"yes")

should suffice.

If column A must have data while column B is "yes"...

=SUMPRODUCT(1-ISBLANK(A2:A100),--(B2:B100="yes"))

The latter won't admit whole column references like A:A as range
arguments.

Spencer Hutton wrote:
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