COUNTIF with reference two 2 different sheets.

gracieenglebert

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?

SueinSpain

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

gracieenglebert

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