How to auto add total data in Excel

[Rao's]

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 i.e. the total number of 'reds' in Z4 total number of 'amber' in Z5? If you guys have any of the suggestion then please do the reply.

[Hollyn]

This is possible with the use of the predefine 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")

Hope this will help you out.