+15 days in sum if criteria?

[Houstonking]

Hello i am trying to do sum if using some dates in a table. But the sumif criteria should be that date + 15 days.

eg i am using currently - SUMIF($B$1:$LF$1,LN2,B2:LF2)

$B$1:$LF$1 - has calender days
B2:LF2 - has values

LN2 has different dates.
i want to add 15 days from LN2 date to do sum.


Need help.Thanks

 

[FDibbins]

Perhaps this?

=SUMIF($B$1:$LF$1,LN2+15,$B$2:$LF$2)

 

[Houstonking]

sorry i need to sumif between the LN2 date and LN2+15

 

[FDibbins]

ah OK, then you need to use sumifS()

=SUMIFs($B$2:$LF$2, $B$1:$LF$1,">="&LN2,$B$1:$LF$1,"<="&LN2+15)

This works for excel 2010 onwards

 

[FDibbins]

This seems to be very similar to your other thread here?

http://www.mrexcel.com/forum/excel-...es-agent-first-15-days-then-next-15-days.html

 

[Houstonking]

yup - got a part from there and edited it and then took your part and got my solution perfect - thanks for your help and love mrexcel.com