Countifs between two dates, multiple sheets

ctsammon

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!

ctsammon

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.

Paul Newcome

You would use a SUMIFS with cross sheet references.

SUMIFS Function | Smartsheet Learning Center

https://help.smartsheet.com/function/sumifs

Adds numbers within a range when all given conditions in their respective ranges are met.