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

"RagDyer" wrote:

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

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Suleman" wrote in message
...
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,