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?