Hi Guys

This formlua has has me stumped, what I am trying to do is...

IF the data in column B equals say POP & the data in Column C equals JOP
that entry receives a count (both entries must be on the same row to receive
a count)


example data
A B C D E
1 POP JOP
2 PPP JOP
3 POP GUP
4 POP JOP
5 YUP KUP
6 POP JOP

So the above table would return the count of 3

any help will be appreciated

=SUMPRODUCT(--(B1:B6="POP"),--(C1:C6="JOP"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"_Scott_" <http://(E-Mail Removed)> wrote in message
news:43a1fc1f$0$13314$(E-Mail Removed)...
> Hi Guys
>
> This formlua has has me stumped, what I am trying to do is...
>
> IF the data in column B equals say POP & the data in Column C equals JOP
> that entry receives a count (both entries must be on the same row to
receive
> a count)
>
>
> example data
> A B C D E
> 1 POP JOP
> 2 PPP JOP
> 3 POP GUP
> 4 POP JOP
> 5 YUP KUP
> 6 POP JOP
>
> So the above table would return the count of 3
>
> any help will be appreciated
>
>

Thanks for that works brilliantly
"Bob Phillips" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> =SUMPRODUCT(--(B1:B6="POP"),--(C1:C6="JOP"))
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "_Scott_" <http://(E-Mail Removed)> wrote in message
> news:43a1fc1f$0$13314$(E-Mail Removed)...
>> Hi Guys
>>
>> This formlua has has me stumped, what I am trying to do is...
>>
>> IF the data in column B equals say POP & the data in Column C equals JOP
>> that entry receives a count (both entries must be on the same row to
> receive
>> a count)
>>
>>
>> example data
>> A B C D E
>> 1 POP JOP
>> 2 PPP JOP
>> 3 POP GUP
>> 4 POP JOP
>> 5 YUP KUP
>> 6 POP JOP
>>
>> So the above table would return the count of 3
>>
>> any help will be appreciated
>>
>>
>
>

are you just counting the POP-JOP combination or would JOP-POP be valid
too?


--
Excelders
------------------------------------------------------------------------
Excelders's Profile: http://www.excelforum.com/member.php...o&userid=15568
View this thread: http://www.excelforum.com/showthread...hreadid=493998