 SOLVED

# 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 payment frequency attributes (annual, quarterly, monthly, fortnightly, weekly and daily) keyed into H column fields, in the row corresponding to the relevant numerical \$ value
*I need a sum of the F column numerical \$ values by identifying the individual numerical \$ values based on their corresponding H column payment frequency attribute

The solution should provide a total sum of the numerical \$ values for each payment frequency
2 Replies
best response confirmed by 1a1nfr1end (New Contributor)
Solution

# Re: Sum of values defined by attribute

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)

# Re: Sum of values defined by attribute

Awesome, thankyou that worked a treat, I did as you suggested and substituted the ; for a ,
Also hard coded the frequency attribute