Help with formula referencing another sheet
I have a sheet titled Vendor Risk with a column called Inherent Risk with ratings High, Moderate and Low.
I have created another sheet that I want to use to store the COUNTIFS to count the number of vendors that were rated High, Moderate and Low.
I have tried using the help bubble with COUNTIFS and I select Reference Another Sheet, but it keeps coming back as unparsable. Can someone help with the correct syntax?
Best Answers
-
NVM - I figured it out
=COUNTIFS({Inherent Risk Range 1}, "High")
-
Hi @capenancy
I'm glad you figured it out! Since you only have one range and criteria you could use a COUNTIF instead (singular), but the COUNTIFS (plural) will work just as well. Plus if you wanted to add another range and criteria it will be easy to adjust.
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Answers
-
NVM - I figured it out
=COUNTIFS({Inherent Risk Range 1}, "High")
-
Hi @capenancy
I'm glad you figured it out! Since you only have one range and criteria you could use a COUNTIF instead (singular), but the COUNTIFS (plural) will work just as well. Plus if you wanted to add another range and criteria it will be easy to adjust.
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!