ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Input (https://www.excelbanter.com/excel-discussion-misc-queries/145423-data-input.html)

Thom

Data Input
 
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
--
Thom

Don Guillett

Data Input
 
Please refer to your ORIGINAL post and do not repost. Confuses all,
including you.

--
Don Guillett
SalesAid Software

"Thom" wrote in message
...
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
--
Thom




All times are GMT +1. The time now is 06:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com