Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

COUNTIF with reference two 2 different sheets.

Hello! I'm trying to use the COUNTIF function to count the number of time different criteria appear across two sheets. For instance, with this function, I'm trying to count how many times the word "Aspen" is selected, but am getting an invalid reference:

=COUNTIFS({2025 People & Culture Task Tracker}, "Aspen") + COUNTIF({2025 CLOSED-People & Culture Task Tracker}, "Aspen")

Can anyone help explain my error?

Answers

  • ✭✭✭✭✭✭

    Personally I would simplify it as it may be the + COUNTIF that it doesn't like

    Use 1 summary field to count from each smartsheet using the countif then a 3rd to add the 2 summary fields together.

    I only learnt this week how to access the summary fields rather than the main smartsheet fields and that is by adding a # at the end of the field name e.g [Start Date] is a smartsheet field and [Start Date]# is a summary field - magic

    Sue Rogers

    AmerisourceBergen - MWI Animal Health

    Business Analyst

  • @SueinSpain

    TY for your answer! When I use the following it's still not working:

    =COUNTIFS({2025 People & Culture Task Tracker}, "Aspen") + ({2025 CLOSED-People & Culture Task Tracker}, "Aspen")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions