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

Normn65 · #1 11-24-2023, 09:57 AM

I have 3 columns with amount delivered in column B, Part # in C and i want to have a running total:

I can get it to show the total of the amounts in D for the last time any duplicate appears, and total for any part# but i can''t get it to add as it goes. What I want is in F

zpy2 · #2 11-24-2023, 05:21 PM

If with sql,

select *,sum(f01) over(partition by f02 order by rowid) running_total from running_total_in_group order by rowid;

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]))

p45cal · #4 11-26-2023, 01:21 PM

See attached.

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