Bring back value based on date

Hello all,
I'm trying to help someone out with a formula to bring back a value based on a certain company and a certain date.
sheet 1 is where im trying to bring back value to its certain date.
project invoice log is where all the information is located.
example:
project invoice log:
Sage Environmental(I5)- $8093.10(M5) - 03/25/10(O5)
sheet 1
Sage Environmental(A3) - $8093.10(AO3)

Hope I explained it enough.
thx in advance
mrggutz

I have attached a sample workbook

I'm not sure exactly what you want, but if I'm right your workbook layout and proposed method will be cumbersome. I suggest you look at how your source data is laid out & consider using a PivotTable

Assuming that you are (both) working in Excel 2003, the SUMPRODUCT function cannot handle full columns. Excel 2007 can but it's not recommended.

So, first step would be to change I:I to, say, I5:I1000. Similarly, U:U and M:M. The "–" should be "--" without quotes.

The formula would look something like this:

Please Login or Register  to view this content.

As RoyUK has said, it looks as though it may be difficult to generalise this.

Regards

If you tried it, why wasn't that in the sample you uploaded?

Where do you intend to put the formula?

I put this in cell W5: [CODE=SUMPRODUCT(--(I5:I1000="Sage Environmental"),--(U5:U1000=U5),(M5:M1000)) [/CODE]


and dragged down; these were the results in W5 to W10

HTML Code: 

Regards

Sumproduct

I note that in your SUMIFS, you are comparing something in A2 to column I.

In the sample, A2 has a heading, A3 has OC-08 and column I has the Vendor names.

We may, therefore, be talking at cross purposes.

I'm sure that's as frustrating for you as it is for me.

Regards

In cell C3 on Sheet1 (in your sample workbook)

Please Login or Register  to view this content.

returns

HTML Code: 

I think this demonstrate the principle; you need to adjust the ranges and search values accordingly.

Regards

You're welcome. Thanks for the feedback.