excel sum 5 different alphabetical row values

October 21, 2011 at 08:58:23
Specs: Windows 7
I have rows with up to 5 separate values - ie SD, D, N, A & SA (responses to a questionaire) for each person responding to the survey. How do I sum all the responses (up to 100 to 20 questions) at the end of each row so that it tells me that for Q3 eg, there were 20xSD, 10xD, 35xN, etc?

See More: excel sum 5 different alphabetical row values

Report •

October 21, 2011 at 09:36:49
Read up on the COUNTIF() function in the Excel Help files.

You can string (concatenate) COUNTIF's and text strings together if you need all of the information in a single cell.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

October 28, 2011 at 12:42:58
Thanks DD - all good.

Report •
Related Solutions

Ask Question