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

regards
FSt1

"Suleman" wrote:

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,