Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
SUMIFS with a date range criteria?
From a project sheet (with additional columns added) I'm trying to tally up the number of days by resource assigned to each quarter. So I want to specify a Q3 date range between 6/1/15 and 8/31/15, for example, as one of the SUMIFS criteria so that I only toal the number of days during that time frame.
Something like so:
=SUMIFS(Days1:Days47, ResourceName1:ResourceName47, "Name", FinishDate1:FinishDate47, [DATE RANGE?])
I found a post online with an equation that does this in Excel:
Is there something similar in Smart Sheet?