Hi Eric

I tried your formula, but I can't seem to get it return the correct result.

When excel evaluate a statement, it return True or False, which will be
turnd to values (1/0) when you multiply theese results (or multiply by 1)

The 1 in the Match function is the value to match, but the function does not
return 1 or 0 but true or false, so if you replace 1 by true, you will not
get #N/A, but the value 700 which is the first match for the date.

I tried the sumproduct formula I have posted earlier, and changed the ranges
to the correct ones, and it returns the correct result on your sample data:

=SUMPRODUCT(--(X8:X900=B8),--(Z8:Z900=D8),--(AD8:AD900=J8),AF8:AF900)

Best regards,
Per

"Eric" skrev i meddelelsen
...
After placing the formula and making it an array formula, I am getting an
error #N/A. I worked on it for hours last night and couldn't figure it
out.
It is probably something small but I can't get it to work. Here is the
formula as I have it in the
bar....{=INDEX(Sheet1!AF8:AF900,MATCH(1,Sheet1!X8: X900=B8)*(Sheet1!Z8:Z900=D8)*(Sheet1!AD8:AD900=J8) ,0)}

sheet1 AF is where the answer is located
Sheet1 x is where the date is located
sheet1 z is where the contract number is located
sheet1 AD is where the mix type is located

sheet1A is where B8, D8, and J8 are located

I do not want to have a sum product

I do have a couple of questions....
1. I thought the * always ment to multiply a formula
2. What does the 1 (after the word Match) mean?

Any help would be appreciated



"Per Jessen" wrote:

Hi Eric

We need a bit more information to help you.

Some sample data would be great along with a description in words of what
you want to do and the expected result.

Regards,
Per

"Eric" skrev i meddelelsen
...
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....