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
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.4K Get Help
- 430 Global Discussions
- 152 Industry Talk
- 492 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 76 Community Job Board
- 504 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!