Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-07-2020, 06:37 PM
Karen615 Karen615 is offline Sum Each Dollar Amount by Phase Windows 7 64bit Sum Each Dollar Amount by Phase Office 2010 64bit
Advanced Beginner
Sum Each Dollar Amount by Phase
 
Join Date: Jun 2011
Location: Chicago
Posts: 88
Karen615 is on a distinguished road
Default Sum Each Dollar Amount by Phase

Hello,




I hope that everyone out there is well.


If this is possible and someone is kind enough to help me, it will be GREATLY appreciated. I would like to try and make this work with my current layout on the "Log" tab.


So, on the "Summary" page, I want to be able to sum the dollar amount from the "Log" tab in column F for each phase when it gets approved. So, by the time everything is approved through all of the phases would amount to $54,465.



I gave an example that I manually calculated on the "Summary" page in column D.


I hope that I am explaining this fully and someone out there can help.


Thank you in advance.
Attached Files
File Type: xlsx Phases.xlsx (13.9 KB, 9 views)
Reply With Quote
  #2  
Old 04-08-2020, 01:10 AM
Logit Logit is offline Sum Each Dollar Amount by Phase Windows 10 Sum Each Dollar Amount by Phase Office 2007
Expert
 
Join Date: Jan 2017
Posts: 459
Logit will become famous soon enoughLogit will become famous soon enough
Default

This method uses HELPER columns and formulas :
Attached Files
File Type: xlsx Phases.xlsx (15.4 KB, 9 views)
Reply With Quote
  #3  
Old 04-08-2020, 03:46 AM
macropod's Avatar
macropod macropod is online now Sum Each Dollar Amount by Phase Windows 7 64bit Sum Each Dollar Amount by Phase Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,857
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

One simple formula per row and no helper columns:
Attached Files
File Type: xlsx Phases.xlsx (13.8 KB, 13 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 04-08-2020, 07:06 PM
Karen615 Karen615 is offline Sum Each Dollar Amount by Phase Windows 7 64bit Sum Each Dollar Amount by Phase Office 2010 64bit
Advanced Beginner
Sum Each Dollar Amount by Phase
 
Join Date: Jun 2011
Location: Chicago
Posts: 88
Karen615 is on a distinguished road
Default

Thank you Logit & Macropod for your generous help. Both methods are great to know. You help is greatly appreciated .
Reply With Quote
  #5  
Old 04-08-2020, 07:07 PM
Logit Logit is offline Sum Each Dollar Amount by Phase Windows 10 Sum Each Dollar Amount by Phase Office 2007
Expert
 
Join Date: Jan 2017
Posts: 459
Logit will become famous soon enoughLogit will become famous soon enough
Default

Glad to help.
Reply With Quote
  #6  
Old 04-08-2020, 07:13 PM
Karen615 Karen615 is offline Sum Each Dollar Amount by Phase Windows 7 64bit Sum Each Dollar Amount by Phase Office 2010 64bit
Advanced Beginner
Sum Each Dollar Amount by Phase
 
Join Date: Jun 2011
Location: Chicago
Posts: 88
Karen615 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
One simple formula per row and no helper columns:

How would the formula need to be altered if I changed column Q to a 10-digit number? See Phases2.xlsx attached.



Your help is greatly appreciated.
Attached Files
File Type: xlsx Phases2.xlsx (14.1 KB, 6 views)
Reply With Quote
  #7  
Old 04-08-2020, 08:44 PM
macropod's Avatar
macropod macropod is online now Sum Each Dollar Amount by Phase Windows 7 64bit Sum Each Dollar Amount by Phase Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,857
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

As was done with column D, use: =SUMPRODUCT((Log!Q2:Q12>0)*1,Log!F2:F12)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 04-08-2020, 11:26 PM
ArviLaanemets ArviLaanemets is offline Sum Each Dollar Amount by Phase Windows 8 Sum Each Dollar Amount by Phase Office 2016
Expert
 
Join Date: May 2017
Posts: 749
ArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to beholdArviLaanemets is a splendid one to behold
Default

Another solution
Attached Files
File Type: xlsx Phases.xlsx (15.6 KB, 7 views)
Reply With Quote
  #9  
Old 04-09-2020, 03:55 PM
Karen615 Karen615 is offline Sum Each Dollar Amount by Phase Windows 7 64bit Sum Each Dollar Amount by Phase Office 2010 64bit
Advanced Beginner
Sum Each Dollar Amount by Phase
 
Join Date: Jun 2011
Location: Chicago
Posts: 88
Karen615 is on a distinguished road
Default

Thank you very much ArviLaanemets!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Get rid of title and phase on swimlane by default wgirlbama Visio 0 02-28-2020 10:00 AM
help creating a dollar counter add-in dstallworth PowerPoint 0 04-23-2017 12:49 PM
mail merge with duplicate names but different dollar amounts bh24524 Mail Merge 27 03-24-2014 01:15 PM
Adding fixed % to different dollar values? mikehende Excel 5 03-05-2013 01:50 PM
Convert Dollar amount to text GeorgeLawshe Word 0 03-07-2010 10:17 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 PM.


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