Solved

Cumulative running balance on multiple sources?

Posted on 2012-03-29
3
369 Views
Last Modified: 2012-03-29
How to do a running (cumulative) balance per SOURCE (and without a Value error because of the heading)?
The data WILL be sorted over and over again.

Sample attached.

Anthony
CumulativeBalances.xlsx
0
Comment
Question by:Anthony Mellor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 37781392
=SUMIF(B$1:B2,B2,E$1:E2)

should work.
0
 
LVL 9

Author Comment

by:Anthony Mellor
ID: 37781639
So simple!

and fascinates me to see it in R1C1 formats because they don't change when copied:

some notes for me, this one replicates the A1 mixed abs/relative style
=SUMIF(R1C[-4]:RC[-4],RC[-4],R1C[-1]:RC[-1])

and this one is absolute
=SUMIF(R1C2:RC2,RC2,R1C5:RC5)
0
 
LVL 9

Author Closing Comment

by:Anthony Mellor
ID: 37781642
I must learn this way of looking at things.
CumulativeBalancesSolved.xlsx
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question