Try this formula:

=SUMPRODUCT(--(X8:X900=B8),--(Y8:Y900=D8),--(Z8:Z900=J8),AA8:AA900)

Regards,
Per

"Eric" skrev i meddelelsen
...
It's not working. I have typed it in exactly as you have specified with
the
exception of the cells

Tons: sheet1A L8 <~~~ search sheet1 AF8:AF900
Date: sheet1A B8 <~~ search sheet1 X8:X900
Project: Sheet1A D8 <~~ search sheet1 Z8:Z900
Mix Type: Sheet1A J8 <~~ Search sheet1 AD8:AD900


The formula is going into cell L8 on sheet1A

B8= 5/25 D8=175.3 J8=12.5 L8=500<~~~this is the answer

X Z AD AF
8 5/25 180.0 12.5 700
9 5/25 190.0 9.5 800
10 5/26 180.0 12.5 800
11 5/25 175.3 12.5 500

HOpe this help somewhat



"Jacob Skaria" wrote:

With

E1 Date
E2 Job Number
E3 Mix Type

and amount in ColumnD try the below array formula..

=INDEX($D$2:$D$9,MATCH(1,($A$1:$A$100=E1)*($B$1:$B $100=E2)*($C$1:$C$100=E3),0))

If you are looking at summing the tons

=SUMPRODUCT(($A$1:$A$100=E1)*($B$1:$B$100=E2)*($C$ 1:$C$100=E3),$D$1:$D$100)

If this post helps click Yes
---------------
Jacob Skaria


"Eric" wrote:

I need to do a search based off of three (3) criterias:

#1 Date
#2 Job Number
#3 Mix Type

Then the amount of tons should show up

Can anyone help please....