as you can see below here i have tow cloumn i want to count the reeferin a
cel from one first colum butt i don,t want to count that reefer which is not
belong to PV (second column).as like i at other cel i just want to count
Equate Reefer not PV.
can any one help me
colum 1
Type Project
Reefer PV
Reefer Equate
Reefer PV
Reefer Equate
Reefer PV

Put this in C1:

=COUNTIF(B:B,"Equate")

Hope this helps.

Pete

On Apr 27, 7:17*pm, Suleman wrote:
as you can see below here i have tow cloumn i want to count the reeferin a
cel from one first colum butt i don,t want to count that reefer which is not
belong to PV (second column).as like i at other cel i just want to count
Equate Reefer not PV.
can any one help me
colum 1
Type * * * * * * * * * * * * * * * * * * * *Project
Reefer * * * * * * * * *PV * * * * * * *
Reefer * * * * * * * * *Equate * * * * *
Reefer * * * * * * * * *PV * * * * * * *
Reefer * * * * * * * * *Equate * * * * *
Reefer * * * * * * * * *PV * * * * * * *