CODEWITHSUNDEEP
excelfunctionsumifs
tylerfutures
tylerfutures

Reputation: 11

SUMIFS with Date Range...but X days before and X days after

I am trying to create a SUMIFS function that is adding totals based on several parameters. The final parameter is to use a date in a column and then look for any dates 7 days prior and 7 days after.

I have a list of invoices I am trying to sum up based on travel...conceivably people who are traveling will travel in a short duration. I cant add all invoices up because someone might travel at the beginning of the month and at the end, creating 2 trips.

Lets say the date is in Column I and my criteria cell is I10, I tried to enter the Criteria Range as "(I10-7)=>I10<=(I10+7)"

But this is clearly wrong. Any help is appreciated!

Upvotes: 1

Views: 802

Answers (1)

user4039065
user4039065

Reputation:

Try,

=sumifs(A:A, I:I, ">="&I10-7, I:I, "<="&I10+7)

Add your other criteria pairs making sure that the criteria ranges are the same number of rows as the sum range.

Upvotes: 1

Related Questions