You might also want to check the condition WS051 to make sure this is how
it's actually reflected in your data set.
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"gcmontgomery30" wrote:

I can't seem to make this work. Does it matter that my data is in a seperate
sheet from where I am putting the formula. When I put in the formula below
based on my real worksheet, the value returned is 0 which is not correct.
Column A is the product, Column B is where the dates are and Column C is Qty
Received values.

=SUMPRODUCT(--('Data Log'!A5:A143="WS051"),--('Data Log'!B5:B143=MAX('Data
Log'!B5:B143)),'Data Log'!C5:C143)
--
gcmontgomery30


"M Kan" wrote:

=SUMPRODUCT(--(Product=A9),--(Date_Ordered=MAX(B3:B7)),Qty_Received)

Where A9 is an input cell where you can enter "test"
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"gcmontgomery30" wrote:

I need to find the value that is in an adjacent cell based on the max (most
recent) date of a certain product number that will show up multiple times in
a seperate worksheet in the workbook and will have emply rows that data will
be added to in the future. I have tried everything to make this work with no
luck. Please Help. Below is an example of what I need. If the product were
test, I need to return the value of 200.

Product Date Ordered Qty Received
test 08/02/08 100
help 08/02/08 50
test 08/05/08 50
test 08/08/08 200
help 08/08/08 100

I would greatly appreciate any help with the formula that will make this work.
--
gcmontgomery30