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.
Bookmarks