Count to show the High Priority Items

Kris Peeters

I would like to add a formula that counts the number of 1 - High, 2 - Med, 3 - Low in each row.

JamesB

@Kris Peeters

you should be able to use =Countifs([Al Javor]@row:[Lisa Young]@row,"1 - High")

Razetto

@Kris Peeters Use the count if formula as: =countif(javor:javor, @cell="1- High") + countif(zarda:zarda, @cell="1- High") +... For the medium and low just change the @cell =

Hope it helps!

Kris Peeters

Here is what I have and it's not working.

=COUNTIF([Al Javoroski]@row:[Lisa Young]@row]="1 - High")

JamesB

@Kris Peeters

you should be able to use =Countifs([Al Javor]@row:[Lisa Young]@row,"1 - High")

Kris Peeters

Yes, that worked thank you!