Need Weekly Sum Function

**neelpatel** · 08-09-2012, 10:13 AM

I need a function which will give a product sum depending on a certain date.

Please see attached.

**ben_hensel** · 08-09-2012, 10:32 AM

If I am understanding what you want, you want to find the number corresponding to the date, right? That is, you're not having excel perform any addition with SUM() or whatever, you're having it find a number that's an already-existing value that happens to be some kind of sum.

That's just a lookup.

Please Login or Register  to view this content.

**neelpatel** · 08-09-2012, 10:36 AM

Your equation does not work properly for 11/1/2012 or 7/1/2012 ...anyway to fix that?

**Melvinrobb** · 08-09-2012, 10:45 AM

This formula would work in cell F2:

Formula:

Please Login or Register  to view this content.

This would find a total of all of the products produced for today.

NOTE: Array formula - Use "CTRL-SHIFT-ENTER"

**neelpatel** · 08-09-2012, 10:48 AM

I love you... thank you so much!

**Cutter** · 08-09-2012, 02:20 PM

@ Melvinrobb

Your formula does not need to be confirmed with CSE.

And the Excel 2007+ equivalent would be:

=SUMIFS(D2:D23,B2:B23,"<="&E2,C2:C23,">="&E2)