Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-24-2023, 09:57 AM
Normn65 Normn65 is offline Running Total dependant on another cells contents if its a duplicate number Windows 11 Running Total dependant on another cells contents if its a duplicate number Office 2021
Novice
Running Total dependant on another cells contents if its a duplicate number
 
Join Date: Nov 2023
Posts: 1
Normn65 is on a distinguished road
Default 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
File Type: xlsx Part totals Delivered.xlsx (16.2 KB, 3 views)
Reply With Quote
  #2  
Old 11-24-2023, 05:21 PM
zpy2 zpy2 is offline Running Total dependant on another cells contents if its a duplicate number Windows 10 Running Total dependant on another cells contents if its a duplicate number Office 2013
Novice
 
Join Date: Sep 2023
Location: China
Posts: 28
zpy2 is on a distinguished road
Default

If with sql,



select *,sum(f01) over(partition by f02 order by rowid) running_total from running_total_in_group order by rowid;
Reply With Quote
  #3  
Old 11-25-2023, 02:33 AM
ArviLaanemets ArviLaanemets is offline Running Total dependant on another cells contents if its a duplicate number Windows 8 Running Total dependant on another cells contents if its a duplicate number Office 2016
Expert
 
Join Date: May 2017
Posts: 857
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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]))
Reply With Quote
  #4  
Old 11-26-2023, 01:21 PM
p45cal's Avatar
p45cal p45cal is online now Running Total dependant on another cells contents if its a duplicate number Windows 10 Running Total dependant on another cells contents if its a duplicate number Office 2021
Expert
 
Join Date: Apr 2014
Posts: 855
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

See attached.
Attached Files
File Type: xlsx msofficeforums51695Part totals Delivered.xlsx (15.0 KB, 2 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Running Total dependant on another cells contents if its a duplicate number How to get total number of cells which has comments in it? kingston123 Excel 1 06-28-2020 06:58 AM
Running Total dependant on another cells contents if its a duplicate number 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 dependant on another cells contents if its a duplicate number Running total possible in a pivot table? 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.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft