Excel Forum



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.