Forum Discussion
SUMIF - sum by any criteria possible?
Hi! I want to have my set of data summed up by each country as in the second table below. Though, is there any way I can get a sum of each country (i e each criteria) without having to specifically ...
Hi
Easier way is by creating pivot table from the data.
PFA
1. conver the data into a table, (Select all, and click Control+ "T")
2. Insert --> pivot table
3. drop the fields as below
4. and you will get the same data, which you can sort too.
Hope this helps.
Contact me for more detailed info
Regards
Supreeth
mailto:supreeth.guptha@gmail.com
8904609867
Thanks a lot, will now make sure to learn to pivot! SupreethGuptha
