|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Running Total dependant on another cells contents if its a duplicate number
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 |
#2
|
|||
|
|||
If with sql,
select *,sum(f01) over(partition by f02 order by rowid) running_total from running_total_in_group order by rowid; |
#3
|
|||
|
|||
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])) |
#4
|
||||
|
||||
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 |