Forum Discussion
Data summation
I'm new to Excel so this may sound a bit simplistic. I have a list of organizational members with addresses, including states and zips. I want to know how many members reside in each state. How do I do that.
Hi Gerald,
If you add names to your columns you may Pivot Table to calculate that, please see attached.
