T
Thom
I have a spreadsheet with a list of names in column A and a list of dates in
column B. In colums C to M I have a list of disciplines with values in rows
for each in row 2 under each discipline. I need to show how many
disciplines per person and the combined total for each value (see
underneath) withouth manually calculating the totals. Can anyone help
Name Date Group1 Group2 Group3 Group4 Group5 Totals
Points awarded 45 42 41 40 38
T.H. 06.05.07 1 1
1 125
Many Thanks
column B. In colums C to M I have a list of disciplines with values in rows
for each in row 2 under each discipline. I need to show how many
disciplines per person and the combined total for each value (see
underneath) withouth manually calculating the totals. Can anyone help
Name Date Group1 Group2 Group3 Group4 Group5 Totals
Points awarded 45 42 41 40 38
T.H. 06.05.07 1 1
1 125
Many Thanks