I want to summarise a row/column of letters, not numbers. It is set up so that all cells are blank apart from if a drop down menu selects the relevant info.
I have created a small example to indicate the issue.
All i want to know is what function i need to use or how to do it.
Bookmarks