=SUMIF for calculating budget on multiple rows.

Hi! I have a sheet that breaks down different accounts. Some line items within an account will have a cost associated with it. I want to be able to calculate the cost of those line items per account. If I do a simple =SUM formula, it gets confused as things are added, changed, filtered etc.

I tried to write a =SUMIF and it worked but only for the first parent/child account. The formula is =SUMIF(Account:Account, "Acct 1", Budget:Budget). But when I go to write the formula for the next Acct. Acct 1 becomes blocked and Acct 2 becomes a circular reference.

I don't want to set a row range because it's constantly changing. Any ideas?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!