calculation problem

[Suleman]

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

 

[Pete_UK]

Try something like this:

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

Hope this helps.

Pete