Help with formula referencing another sheet

Question

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?

capenancy · Accepted Answer

NVM - I figured it out

=COUNTIFS({Inherent Risk Range 1}, "High")

Genevieve P. · Accepted Answer

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