Counting

[Suleman]

i am afcing one problem
i want to count two prject in one cel
Example

A B
Reefer PV
Reefer PV
Reefer Equate
Reefer Equate
Reefer L.D
Reefer Supreme

I Wnat To Count the Reefer belong to PV and Equate In One Cell A1,

 

[RagDyer]

With the datalist in A1 to B6, enter this in C1:

=Sumproduct((A1:A6="Reefer")*(B1:B6="PV"))

 

[Suleman]

butt friend i need Pv and Equate in One Cel
I mena Reefer Belong tO Pv and Reefer Belong to Equate Both in one Cell

You Formula Just able to count the reefer belong to Pv it will not count the
equate reefer

 

[FSt1]

hi
try this
=SUMPRODUCT((A14:A19="Reefer")*(B14:B19="PV")+(A14:A19="Reefer")*(B14:B19="Equate"))

regards
FSt1

 

[RagDyer]

Sorry, I misread.

Try this:

=SUMPRODUCT((A1:A6="Reefer")*(B1:B6={"PV","Equate"}))