Adding Second Sheet to Countifs formula

The reference sheet for my COUNTIFS formal has maxed out the number of rows available so I created another sheet to reference.

How do I add the second sheet to this COUNTIFS formula:

=COUNTIFS({Next Follow Up Jun}, <=DATE(2022, 8, 31), {Next Follow Up Jun}, >=DATE(2022, 8, 1), {OM5}, "Stacy Redd")

Find more posts tagged with

Accepted answers

DesireeJones

I just had this happen to one of my projects and all I did was add another COUNTIFS formula with a "+" sign to my original COUNTIFS formula.

For an example:

=COUNTIFS({Next Follow Up Jun}, <=DATE(2022, 8, 31), {Next Follow Up Jun}, >=DATE(2022, 8, 1), {OM5}, "Stacy Redd") + COUNTIFS(this formula would reference the second sheet)

All this would do would add the COUNTIFS formulas together to give you a total count.

Let me know if this works for you! :)

All comments

DesireeJones

I just had this happen to one of my projects and all I did was add another COUNTIFS formula with a "+" sign to my original COUNTIFS formula.

For an example:

=COUNTIFS({Next Follow Up Jun}, <=DATE(2022, 8, 31), {Next Follow Up Jun}, >=DATE(2022, 8, 1), {OM5}, "Stacy Redd") + COUNTIFS(this formula would reference the second sheet)

All this would do would add the COUNTIFS formulas together to give you a total count.

Let me know if this works for you! :)

Travis Horton

@DesireeJones Thank you for the quick response. There should be data on the new sheet tomorrow so I can test out your suggestion. I'll let you if it works...seems likely that it will.

Travis Horton

@DesireeJones It worked! Thank you!!

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.