Microsoft Office Forums Running Total dependant on another cells contents if its a duplicate number
 Register FAQ Search Today's Posts Mark Forums Read

#1
11-24-2023, 09:57 AM
 Normn65 Windows 11 Office 2021 Novice Join Date: Nov 2023 Posts: 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
Attached Files
 Part totals Delivered.xlsx (16.2 KB, 3 views)
#2
11-24-2023, 05:21 PM
 zpy2 Windows 10 Office 2013 Novice Join Date: Sep 2023 Location: China Posts: 28

If with sql,

select *,sum(f01) over(partition by f02 order by rowid) running_total from running_total_in_group order by rowid;
#3
11-25-2023, 02:33 AM
 ArviLaanemets Windows 8 Office 2016 Expert Join Date: May 2017 Posts: 857

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:
running total:
=IF(OR([@AmountName]="",[@PartNumberName]=""),"",SUMIFS([AmountName],[PartNumberName],[@PartNumberName],[RowNumberName],"<" & [@RowNumberName]))```
#4
11-26-2023, 01:21 PM
 p45cal Windows 10 Office 2021 Expert Join Date: Apr 2014 Posts: 855

See attached.
Attached Files
 msofficeforums51695Part totals Delivered.xlsx (15.0 KB, 2 views)

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post kingston123 Excel 1 06-28-2020 06:58 AM trevorc Excel 4 02-08-2018 07:27 PM cdon1983 Excel 7 09-07-2017 05:12 AM Mikayla Excel 1 03-15-2017 06:19 AM Chancy Excel 3 03-02-2015 01:20 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:38 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top