If you are using SUMPORODUCT() then it is a normal formula

=SUMPRODUCT((X8:X900=B8)*(Z8:Z900=D8)*(AD8:AD900=J 8),AF8:AF900)


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

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


"Jacob Skaria" wrote:

Please note that this is an array formula. Within the cell in edit mode (F2)
paste this formula and press Ctrl+Shift+Enter to apply this formula. If
successful in 'Formula Bar' you can notice the curly braces at both ends like
"{=<formula}"

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


"Eric" wrote:

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....