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

Options
✭✭

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({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))

• ✭✭✭✭✭✭
Options

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))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!