+15 days in sum if criteria?

Houstonking

New Member
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

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

FDibbins

Well-known Member
Perhaps this?

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

Houstonking

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

FDibbins

Well-known Member
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

Houstonking

New Member
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

Replies
5
Views
246
Replies
8
Views
935
Replies
5
Views
344
Replies
6
Views
444
Replies
7
Views
426

1,190,590
Messages
5,981,816
Members
439,736
Latest member
Nathan20

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back