I need to sum up values only if a chosen column has the same reference number.
example: Please help me.

COL A COL B COL C COL D COL E COL F
102 427 427
TOTAL FOR # 102 (B,C,D,E,F HAVING THEIR SEPARATE SUMMATION)
108 528 0 528 0 0
TOTAL FOR # 108 (B,C,D,E,F HAVING THEIR SEPARATE SUMMATION)
113 42 42
114 3 3
114 58 4
114 48 48
TOTAL FOR # 114 (B,C,D,E,F HAVING THEIR SEPARATE SUMMATION)
115 67 67
115 14 14
115 853 853
115 22 22
115 1704 1623
115 234 234
115 16 16
TOTAL FOR # 115 (B,C,D,E,F HAVING THEIR SEPARATE SUMMATION)

I think you are looking for Subtotals

Men u DataSubTotals...

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Ange" wrote in message
om...
I need to sum up values only if a chosen column has the same reference
number.
example: Please help me.

COL A COL B COL C COL D COL E COL F
102 427 427
TOTAL FOR # 102 (B,C,D,E,F HAVING THEIR SEPARATE SUMMATION)
108 528 0 528 0 0
TOTAL FOR # 108 (B,C,D,E,F HAVING THEIR SEPARATE SUMMATION)
113 42 42
114 3 3
114 58 4
114 48 48
TOTAL FOR # 114 (B,C,D,E,F HAVING THEIR SEPARATE SUMMATION)
115 67 67
115 14 14
115 853 853
115 22 22
115 1704 1623
115 234 234
115 16 16
TOTAL FOR # 115 (B,C,D,E,F HAVING THEIR SEPARATE SUMMATION)