Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
Hi
I have a long list of RAG report status's either a G, R or A. I need to write a formula to total them giving me a number EG G = 8 What would this look like please? They are all in the same column |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
If they are in column A (adjust your range as appropriate)
=COUNTIF(A1:A500,"R") =COUNTIF(A1:A500,"A") =COUNTIF(A1:A500,"G") to give you three totals "Ryan" wrote: Hi I have a long list of RAG report status's either a G, R or A. I need to write a formula to total them giving me a number EG G = 8 What would this look like please? They are all in the same column |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|