Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-15-2016, 02:17 PM
brentcfocus brentcfocus is offline Sum the (filtered) remaining work column Windows 7 64bit Sum the (filtered) remaining work column Office 2013
Novice
Sum the (filtered) remaining work column
 
Join Date: Mar 2016
Posts: 2
brentcfocus is on a distinguished road
Default Sum the (filtered) remaining work column

I use a separate text column to indicate tasks assigned to various project managers. There are multiple sub-projects within the project. I've created a filter that shows tasks assigned per that column which then allows me to see remaining work, but I cannot find an easy way to sum the remaining work column. I currently copy and paste it into excel, but I'd like to do it all within MSP. Does anyone have a method for this?
Reply With Quote
  #2  
Old 03-21-2016, 06:53 AM
JulieS JulieS is offline Sum the (filtered) remaining work column Windows 7 64bit Sum the (filtered) remaining work column Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

Hi Brent,
Filtering does not change the summary values Consider grouping by the project manager assigned. The remaining work should be summarized by group.
Reply With Quote
  #3  
Old 03-21-2016, 10:25 AM
brentcfocus brentcfocus is offline Sum the (filtered) remaining work column Windows 7 64bit Sum the (filtered) remaining work column Office 2013
Novice
Sum the (filtered) remaining work column
 
Join Date: Mar 2016
Posts: 2
brentcfocus is on a distinguished road
Default

Excellent suggestion. I have not used grouping to any great extent. This is a great quick solution. Thank you.
Reply With Quote
  #4  
Old 03-21-2016, 08:34 PM
JulieS JulieS is offline Sum the (filtered) remaining work column Windows 7 64bit Sum the (filtered) remaining work column Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're welcome and thanks for the feedback.
Reply With Quote
Reply

Tags
sum

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula to work from data column masterdineen Excel 16 08-09-2012 07:52 AM
Change Resource Time vs. Duration when Updating Work column lylel Project 3 07-23-2012 06:09 PM
Displaying Work Week instead of date in a column. whitney07 Project 1 07-05-2012 02:27 PM
Sum the (filtered) remaining work column definition of work column ketanco Project 9 05-31-2012 05:15 PM
Sum the (filtered) remaining work column adjusting remaining work per status date ketanco Project 1 03-16-2012 06:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:14 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