How to add two Countifs that are pulling information from two different sheets

Hi Everyone,

I am trying to create edit a function to include another Countifs statement and add them up however I am unable to get this to work. I have tested out one of the separate countifs functions and know it works independently to count. Any help on how to combine the two and produce a total number would be appreciated.

I am just trying to count the amount of rows we have in a column that fall under the dates mentioned.

=COUNTIFS({New Postdoc Appointments Range 1}, {New Postdoc Appointments Range 1} >= DATE(2023, 5, 1), {New Postdoc Appointments Range 1}, {New Postdoc Appointments Range 1} <= DATE(2023, 5, 31))

Find more posts tagged with

Accepted answers

All comments

Carson Penticuff

Both of the formulas you have listed should work as it. To combine them, you would just add the two statements together:

=COUNTIFS({Postdoc New Appointment Archive Range 1}, {Postdoc New Appointment Archive Range 1} >= DATE(2023, 5, 1), {Postdoc New Appointment Archive Range 1}, {Postdoc New Appointment Archive Range 1} <= DATE(2023, 5, 31)) + COUNTIFS({New Postdoc Appointments Range 1}, {New Postdoc Appointments Range 1} >= DATE(2023, 5, 1), {New Postdoc Appointments Range 1}, {New Postdoc Appointments Range 1} <= DATE(2023, 5, 31))

You can shorten this a bit, as restating the range in the countifs is unnecessary:

=COUNTIFS({Postdoc New Appointment Archive Range 1}, >= DATE(2023, 5, 1), {Postdoc New Appointment Archive Range 1}, <= DATE(2023, 5, 31)) + COUNTIFS({New Postdoc Appointments Range 1}, >= DATE(2023, 5, 1), {New Postdoc Appointments Range 1}, <= DATE(2023, 5, 31))

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.