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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
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
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!