
SUMIFS Function | Smartsheet Learning Center
https://help.smartsheet.com/function/sumifsAdds numbers within a range when all given conditions in their respective ranges are met.
Sheet 1 has a column "Date Conducted". Another column "Status" with dropdown options "Safe" and "Improve"
Summary Sheet has two columns, "Start Date" and "End Date".
On the summary sheet, I'm trying to count the number of "Improve" where the "Date Conducted" is between the "Start Date" and "End Date".
Any ideas?
Thanks!
Sorry, I did not type that correctly.
Sheet 1 has a column "Total Improve" which sums the counts of each column marked as "Improve".
I'm trying to sum the "total improves" from sheet 1 that fall between the "Start Date" and "End Date" from the summary sheet.
You would use a SUMIFS with cross sheet references.