Using SUMIFS with dates

Hi,

I am trying to create a formula for summarizing data from a time log. I have a row with person's name, auto-generated row creation date and time spent in hours. I would like to make a formula that takes the sum of times spent only for a specific name and only if the created date was in the last 7 days. I am doing the calculations in a separate sheet so I have to use cross sheet references for the data validation.

I was able to get the first part to work where it only sums items where name matches:

=SUMIF({Summarizer 2.0 Range 1}, Name@row, {Summarizer 2.0 Range 2})

But I cannot get the date part to work. Here is what I tried:

=SUMIFS({Summarizer 2.0 Range 1}, Name@row, {Summarizer 2.0 Range 2}, {Summarizer 2.0 Range 3}, >=TODAY(-7))

Any idea what I am doing wrong?

Find more posts tagged with

Accepted answers

All comments

Mark Cronk

Hi @Walter Simpson ,

Try:

=SUMIFS( {Summarizer 2.0 Range 2}, {Summarizer 2.0 Range 1}, Name@row,{Summarizer 2.0 Range 3}, @cell>=TODAY(-7))

Work?

Mark

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.