Looking up a series of values over a date range?

**Kitsan** · 10-10-2012, 05:32 AM

I'm creating a weekly cash reconciliation tab X to tack on to the monthly spreadsheet taking information from Oct tab Y.

I want to build a formula on X which will lookup the date range 07/10/12 and 13/10/12 on Y and then add up all the cash values of transactions which happened during that period.

I'm not the best on excel but i'm not the worst and this one is killing me! I hope you guys can help?

**Blake 7** · 10-10-2012, 05:37 AM

sounds like you could use a Sumproduct formula. The best bet would be to upload a sample workbook

**Kitsan** · 10-10-2012, 05:59 AM

How do I upload a file, I keep getting error messages while trying to upload using the forum?

**Kitsan** · 10-10-2012, 07:05 AM

I don't know if this helps but this is the fomula i'm trying to use: =SUMPRODUCT(('Oct 12'!F20:F71>=A9),('Oct 12'!F20:F71<B9),'Oct 12'!K20:K71)

A9 is the beginning of the week and B9 is the end of the week.
F20:F71 is the date column
K20:K71 is the monetary column

**Kitsan** · 10-10-2012, 07:13 AM

123.xlsx

whey! I'm a genius

**Blake 7** · 10-10-2012, 08:05 AM

in which cell on tab x do you want the formula to go?

**Kitsan** · 10-10-2012, 08:17 AM

Thanks guys but I managed to fumble around until I got it sorted out myself:

=SUMIF('Oct 12'!$F$20:$F$71,"<"&B9,'Oct 12'!$K$20:$K$71)-SUMIF('Oct 12'!$F$20:$F$71,"<"&A9,'Oct 12'!$K$20:$K$71)

That formula relates to my actual ss not my attachment obviously!

I'm sure i'll be back at some point