Hello,
I have two columns: Col C, yes, yes, no, yes, yes and Col D, yes, no, yes,
yes, Yes. I want to count on col D if it says yes and the coresonding cell
in Col C says yes. Thus I would like a formula to return a count of 3 for
this example.
Hello,
I have two columns: Col C, yes, yes, no, yes, yes and Col D, yes, no, yes,
yes, Yes. I want to count on col D if it says yes and the coresonding cell
in Col C says yes. Thus I would like a formula to return a count of 3 for
this example.
{=SUM(IF((C1:C100="yes"),IF(D1:D100="yes",1,0)))}
You would obviously substitute the C1:C100 and D1:D100 with the range you need.
This is not case sensative
You could leave out the IF statements (either way works, but with more
complex formulae you could have problems w/the 7 nested function limit using
IF statements).
{=SUM((F4:F7="yes")*(G4:G7="yes"))}
or
=SUMPRODUCT(--(F4:F7="yes"), --(G4:G7="yes"))
"nevi" wrote:
>
> {=SUM(IF((C1:C100="yes"),IF(D1:D100="yes",1,0)))}
>
> You would obviously substitute the C1:C100 and D1:D100 with the range
> you need.
>
> This is not case sensative
>
>
> --
> nevi
> ------------------------------------------------------------------------
> nevi's Profile: http://www.excelforum.com/member.php...o&userid=33238
> View this thread: http://www.excelforum.com/showthread...hreadid=552861
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks