Sum of values defined by attribute

I need to display the sum of individual numerical $ values which are defined by the attribute of payment frequency E.g. * I have individual numerical $ values keyed into F column fields * I have pa...

excel

Formulas and Functions

Martin_Weiss
Mar 07, 2022
Hi 1a1nfr1end

you can do this by using SUMIF-function.

Here is my example:
=SUMIF($C$2:$C$10;A13;$B$2:$B$10)
Of course, you could hardcode the criteria in the formula like this
=SUMIF($C$2:$C$10;"weekly";$B$2:$B$10)
But I propose to reference a cell which contains the criteria.

Just make sure the spelling of the criteria matches the spelling in the list. And that both ranges have the same size (in my example C2:C10 and B2:B10)

Depending on your local setttings, you might need to use , instead of ; in your formulas:
=SUMIF($C$2:$C$10,A13,$B$2:$B$10)

Martin_Weiss

Bronze Contributor

Mar 07, 2022

Hi 1a1nfr1end

you can do this by using SUMIF-function.

Here is my example:

=SUMIF($C$2:$C$10;A13;$B$2:$B$10)

Of course, you could hardcode the criteria in the formula like this

=SUMIF($C$2:$C$10;"weekly";$B$2:$B$10)

But I propose to reference a cell which contains the criteria.

Just make sure the spelling of the criteria matches the spelling in the list. And that both ranges have the same size (in my example C2:C10 and B2:B10)

Depending on your local setttings, you might need to use , instead of ; in your formulas:

=SUMIF($C$2:$C$10,A13,$B$2:$B$10)

1a1nfr1end
Copper Contributor
Mar 07, 2022
Awesome, thankyou that worked a treat, I did as you suggested and substituted the ; for a ,
Also hard coded the frequency attribute

Forum Discussion

Sum of values defined by attribute

Resources