As You Can See Below My Question I Used It And Its Working
butt One Problem I Ma FAcing

Column A1 ColumnF1
Reefer Rejected

I Want To Calculate That Reefer Which Is Rejected At sheet 2
Its Not working Can You Help Me

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

Try something like this:

=SUMPRODUCT((Sheet2!A1:A100="Reefer")*(Sheet2!F1:F 100="Rejected"))

Hope this helps.

Pete

On Apr 30, 5:54*pm, Suleman wrote:
As You Can See Below My Question I Used It And Its Working
butt One Problem I Ma FAcing

Column A1 * * * * * * * * * * ColumnF1
Reefer * * * * * * * * * * * * *Rejected

I Want To Calculate That Reefer Which Is Rejected At sheet 2
Its Not working Can You Help Me

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 * * *- Hide quoted text -

- Show quoted text -