One of these.................

=SUMPRODUCT((A1:A12="Reefer")*(B1:B12="Equate"))

=SUM(IF(A1:A12="Reefer",IF(B1:B12="Equate",1,0),0) )

Second one has to be entered using CTRL + SHIFT + ENTER as it is an Array
fomula.

For more on this type of formula see Bob Phillips' site.

http://www.xldynamic.com/source/xld.SUMPRODUCT.html


Gord Dibben MS Excel MVP

On Sun, 27 Apr 2008 11:37:00 -0700, Suleman
wrote:


thanks Pete for reply

butt here is also problem some time equate have thier bobtial and flatbed i
need to calculate seprate bobtail and flatbed belong equate if i calculate
the equate then it will all calculate not just reefer below some samle of
same problem with pv also i need that i can calculate the reefer which belong
Pv and can calculate the bobtail with Belong PV and at anothoer cell
i hope are you understanding me

Type Project
Reefer PV
Reefer Equate
Reefer PV
bobtail Equate
Reefer PV
Type Project
Reefer PV
Reefer Equate
Bobtail PV
Flatbed Equate
Reefer PV


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