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