Sum of multiple running totals

[Starmusk10]

I have a sheet where I keep track of 20+ expense accounts. Each account balance is a running total. Each time I want to add up all the balances I have to select each balance and add them together either on a calculator or a simple =sum(e35,l33,s34,z28). Is there a way that I can do this automatically in a separate cell? I would like the sum to always add the last balance amount. I have attached a sample of my sheet.

Thank you in advance for your help.
Todd

[63falcondude]

Try

=SUM(LOOKUP(2,1/(E4:E100<>""),E4:E100),LOOKUP(2,1/(L4:L100<>""),L4:L100),LOOKUP(2,1/(S4:S100<>""),S4:S100),LOOKUP(2,1/(Z4:Z100<>""),Z4:Z100))

[JohnTopley]

What output are you expecting:

Each time I want to add up all the balances

Where is this to appear?

[tim201110]

if one make total row above tables, then sumif

[Starmusk10]

This works great! Thank you for the quick response.

[63falcondude]

Not sure which response you are referring to but either way, glad we could help.

If that solved your question, please mark this thread as SOLVED.

[avk]

In another way you can do this.
Refer attach file in row 3. (which insert row)
In "A3" "H3" O3" "V3" use max formula. (one example

Please Login or Register  to view this content.

In ""G3" "N3" "U3" "AB3" : use sumif formula. (One example

Please Login or Register  to view this content.

In "AC3" :

Please Login or Register  to view this content.

Or In "AD3"

Please Login or Register  to view this content.