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,