Adding Second Sheet to Countifs formula

Travis Horton · 08/17/22

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

DesireeJones · 08/17/22

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

DesireeJones · 08/17/22

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 · 08/17/22

@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 · 08/18/22

@DesireeJones It worked! Thank you!!

Adding Second Sheet to Countifs formula

Best Answer

Answers

Help Article Resources

Categories