Solved

Cumulative running balance on multiple sources?

Posted on 2012-03-29
3
352 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
  • 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Everything left of comma in excel 4 44
Excel change font color in formula 19 28
excel conditional formating 4 14
V-Lookup 11 17
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

808 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