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

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

Okay, put Reefer, Bobtail and Flatbed in cells C1 to C3, and put this
formula in D1:

=SUMPRODUCT((A$1:A$1000=C1)*(B$1:B$1000="Equate"))

and copy this into D2:D3. It should give you the subtotals you want
for each of the categories in column C.

I've assumed you have data in rows 1 to 1000, so adjust this if you
have more.

Hope this helps.

Pete

On Apr 27, 7:37*pm, 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 * * * * * * *

Try one of these...

=COUNT(INDEX(SEARCH("Reefer",A1:A100)/(B1:B100="Equate"),0))

=SUM(INDEX((A1:A100="Reefer")*(B1:B100="Equate"),0 ))


"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