Help with formula referencing another sheet

capenancy

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

NVM - I figured it out

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

Genevieve P.

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

capenancy

NVM - I figured it out

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

Genevieve P.

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