Sum Rollup

[Iman]

My data:

Name Total Cost1 Cost2 Cost3
District 01 $0.00 $0.00 $0.00 $0.00
01-3116U $0.00 $0.35 $33.86 $25.57
01-3634U $0.00 $0.50 $121.55 $36.16


Ineed the rolled up summary line (District 01) to sum up the lines below.
That is, Cost1 should say $.085, Cost2 should say $155.41, Cost3 should say
$61.73 and Total should say $217.99

I tried Customized Field, but obviously I am missing something. Please need
help

 

[Annie]

Hello "Iman",
Simple Sums should work fine.
District 01 =SUM(C2:E2) Cost1=SUM(C3:C4) Cost2=SUM(D34) Cost3=SUM(E3:E4)
Cheers,
Annie

 

[John M.]

On the definition of the custom field (Tools --> Customize --> Fields),
there is a section for each custom field as to how to handle summary tasks
(calculation for task and summary group rows). Select the "Rollup" option
and then choose "Sum" in the related drop-down list.

John M.

 

[Annie]

Sorry Iman. Thought I was still in Excel discussion. Annie

 

[Iman]

Yes, but it does not work!

On the definition of the custom field (Tools --> Customize --> Fields),
there is a section for each custom field as to how to handle summary tasks
(calculation for task and summary group rows). Select the "Rollup" option
and then choose "Sum" in the related drop-down list.

John M.