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
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 [email protected]> schrieb im
Newsbeitrag news:[email protected]...
> 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 [email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks