Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Project

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 08-22-2017, 05:26 AM
Grizz1955 Grizz1955 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Aug 2017
Location: Fairmont,WV
Posts: 1
Grizz1955 is on a distinguished road
Question Formulas help

I have MS Project 2013 Pro. I began by making 3 separate task sections.



Completed projects, Active Projects and Opportunities. I would like to make a formula that subtotals individual columns in those sections.
And at the very top have those individual colunms in those sections total in row 1.
The colunms are:
Time (In days)
Total Sq Ft (0,0)
Project Value ($)
Complete (%)
See attachment example in excel.
Can anyone help me figure out the formula for each?
Attached Files
File Type: xlsx 2017 Schedule 8-17.xlsx (11.9 KB, 2 views)
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
help with formulas ferrarifx Excel 2 11-16-2016 12:04 PM
VBA formulas zhead Excel Programming 17 02-09-2016 03:41 AM
Using Right and Len formulas together PDGood Excel 4 11-20-2015 06:50 AM
Help with IF or ELSE Formulas tsaladyga Excel 4 07-23-2014 09:04 AM
IF Formulas mizzamzz Excel 1 07-08-2010 02:32 AM


All times are GMT -7. The time now is 06:28 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft