Countifs between two dates, multiple sheets

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!

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

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

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.