#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data Input Bud Schenke Excel Worksheet Functions 0 December 6th 06 10:56 PM
Data Input Shanor Excel Discussion (Misc queries) 0 June 22nd 06 05:36 PM
Data Input Rich Stanek Excel Discussion (Misc queries) 1 March 22nd 06 09:45 PM
How do I add input data in the input ranges in drop down boxes. oil_driller Excel Discussion (Misc queries) 1 November 9th 05 10:31 PM
Running Data Table using an input that triggers DDE linked data [email protected] Excel Discussion (Misc queries) 1 December 16th 04 11:56 AM


All times are GMT +1. The time now is 01:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"