Forum Discussion

helli76's avatar
helli76
Copper Contributor
Jun 26, 2020

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 ...
excel
Formulas and Functions
peteryac60's avatar
peteryac60
Iron Contributor
Jun 26, 2020

helli76 

 

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.

 

hope that helps!

 

Peter

  • helli76's avatar
    helli76
    Copper Contributor
    Jun 29, 2020

    Thanks, also for the instruction! peteryac60 

Resources