How do I use a countif formula to count the number of various priorities?

dacey.hartsfield73521 · 12/30/18

I have a column for priority which returns symbols. Exclamation = high, dash = medium, and down arrow = low.

I have tried various formulas and nothing is working.

I basically want to know the amount of highs, mediums, and lows in my sheet.

Help please!

Thanks,

Dacey

Andrée Starå · 12/30/18

Hi Dacey,

Try this.

Change Hight to Medium, Low to count them.

=COUNTIF(Priority:Priority; "High")

The same version but with the below changes for your and others convenience.

=COUNTIF(Priority:Priority, "High")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Happy Holidays & Happy New Year!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

dacey.hartsfield73521 · 01/06/19

The formula with the comma worked perfectly. Thank you so very much!

Andrée Starå · 01/06/19

Great!

Happy to help!

Best,

Andrée

Comments