Running Total dependant on another cells contents if its a duplicate number

ArviLaanemets · #3 11-25-2023, 02:33 AM

I don't have Excel available at moment, so I can't see what you have in your attached workbook, but on fly:

Add a column, where the number of table row is calculated. Something like =ROW()-1,
where the number is number of header row.

Use SUMIFS() to calculate the sum for all part numbers equal to current one, with table row less than current one.

My advice is, use Defined Table instead regular one - so all formulas will be updated atumatically whenever a row is added. Then the formulas will be like

Code:

row number:
= ROW() - ROW(YourTableName[[#Headers],[AnyColumnName]])
running total:
=IF(OR([@AmountName]="",[@PartNumberName]=""),"",SUMIFS([AmountName],[PartNumberName],[@PartNumberName],[RowNumberName],"<" & [@RowNumberName]))

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to get total number of cells which has comments in it?	kingston123	Excel	1	06-28-2020 06:58 AM
running total formula	trevorc	Excel	4	02-08-2018 07:27 PM
Formula for a running total in one cell	cdon1983	Excel	7	09-07-2017 05:12 AM
Running total automated	Mikayla	Excel	1	03-15-2017 06:19 AM
Running total possible in a pivot table?	Chancy	Excel	3	03-02-2015 01:20 PM