SUMIF - sum by any criteria possible?

Question

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 define each country? In other words, can Excel automatically produce the complete second table?Thanks!Helli&nbsp;&nbsp;

wumolad · Answer

helli76&nbsp;&nbsp;You can use pivot table&nbsp;Cheers

peteryac60 · Answer

helli76&nbsp;&nbsp;Using a SUMIF then the answer (I'm afraid) is no.But if you use a pivot table - see example below - it will work easily.&nbsp;hope that helps!&nbsp;Peter

supreethguptha · Answer

helli76&nbsp;&nbsp;Hi&nbsp;Easier way is by creating pivot table from the data.PFA&nbsp;1. conver the data into a table, (Select all, and click Control+ "T")&nbsp;2. Insert --&gt; pivot table&nbsp;3. drop the fields as below4. and you will get the same data, which you can sort too.&nbsp;&nbsp;Hope this helps.&nbsp;Contact me for more detailed info&nbsp;RegardsSupreethmailto:supreeth.guptha@gmail.com8904609867&nbsp;

helli76 · Answer

Of course, thanks!&nbsp;wumolad&nbsp;

helli76 · Answer

Thanks, also for the instruction!&nbsp;peteryac60&nbsp;

Forum Discussion

SUMIF - sum by any criteria possible?

6 Replies

Resources