RAG Formulas

Faye Rhodes

I have a project sheet and I have used formulas to create metrics.

I have a RAG column and want  to simply create four metrics:

I am struggling to find the correct formula to simply count the following:

• RAG Status Green
• RAG Status Blue
• RAG Status Amber
• RAG Status Red

Many Thanks

 

 

Mitch.Shaffer

Try using this formula:

="Green: " + COUNTIF(RAG:RAG, "Green") + " Blue: " + COUNTIF(RAG:RAG, "Blue") + " Amber: " + COUNTIF(RAG:RAG, "Yellow") + " Red: " + COUNTIF(RAG:RAG, "Red")

I don't know what your column title is, so I just used RAG. Be sure to update the sections in italics correspond to the column you want to count.