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 -