Excel Forum
Similar Content
Make Negative Numbers Positive in Excel and Vice Versa
Tutorial: I will show you a few ways to change negative numbers to positive numbers and back again ...
Convert Numbers Stored as Text to Numbers in Excel
Tutorial: I'll show you 4 ways to convert numbers stored as text to numbers in Excel.  This situat...
Make a UserForm in Excel
Tutorial: Let's create a working UserForm in Excel. This is a step-by-step tutorial that shows you e...

Excel Magic Trick 415: Summarize Survey Results 2 Different Methods

See how to summarize survey results (Psychology test) with:
1) Array Formula with SUM, COUNTA and IF functions.
2) VLOOKUP and Data Validation Drop Down List.

Got a Question? Ask it Here in the Forum.