auto populate?
 

hi there and thank you in advance for any help anyone can provide.
i have a spreadsheet with a RAG formula in column A (created with help from a very kind member of this forum) what i would like to do now is pool these results into a sub table. Is there any way to get an automatic total off the rag status ie the total number of 'reds' in Z4 total number of 'amber' in Z5?
Hope this makes sense

Use a COUNTIF() formula, for example:

Column A holds your RAG statuses (e.g. Green, Amber, Red), in Cell B1 you want the total number of Reds, so type in the formula:
=COUNTIF(A:A,"Red")