Help with Sumif function with multiple crieteria

**greenbean0021** · 01-19-2012, 09:39 AM

I am new to the forum and need some help with a sumif function. I am attempting to take a date, see if it is in a list of dates, if so, return the sum of the values 60 days before and 60 days after that date in two separate columns. The date changes along with the data fields. Please help. Thanks.

**zbor** · 01-19-2012, 09:56 AM

Please, upload example workbook and write where you want your result.

**canapone** · 01-19-2012, 10:00 AM

Hi,

I imagine the dates in row 2 (from column B to DC) and the numbers to be summed below (rows 2-1000).

The date to compare +60 -60 (the formula subtracts two months) in A2

Please Login or Register  to view this content.

Maybe if you upload a sample file, you'll receive a more tailored solution.

Regards

Edit: Sorry Zbor, did not mean to overlap. Regards

**zbor** · 01-19-2012, 10:02 AM

You didn't overlap. Great if it works. I just was to lazy for delimiting data :D

**greenbean0021** · 01-19-2012, 04:20 PM

Thanks for your help, but when i use this string, I get a product that's a date, not 7 the answer for 60 days before, and 9 for 60 days after. not sure what's going on. Thanks.

Hi,

I imagine the dates in row 2 (from column B to DC) and the numbers to be summed below (rows 2-1000).

The date to compare +60 -60 (the formula subtracts two months) in A2

=SUMPRODUCT((C2:DC2>=DATE(YEAR(A2),MONTH(A2)-2,DAY(A2)))*(C2:DC2<=DATE(YEAR(A2),MONTH(A2)+2,DAY(A2)))*C3:DC1000)

Maybe if you upload a sample file, you'll receive a more tailored solution.

Regards

Edit: Sorry Zbor, did not mean to overlap. Regards[/QUOTE]