Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet with a list of names in column A along the top in rows
B to M I have a discipline with points awarded shown in Row 2 I need to illustrate who has worked in the disciplines and the points awarded. However I currnetly calculate them individually and this is becoming very time consuming. How do I do this ? Please see sample! Name Date Group 1 Group 2 Group 3 Group 4 TOTAL Points Awarded 45 38 36 34 T H 05.04.07 1 1 1 117 Any help would be appreciated ! Regards Thom |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
Assuming Points Awarded are in Row B and First Row of Data is Row C. And Data is in Cols C, D, E, F and total in G. The way Excel works you can just multiply each of the four entries in the current row with the relevant entry in the first row. If the current row entry is blank then the sum for that cell will be zero. The formula will look like this: =C3*$C$2+D3*$D$2+E3*$E$2+F3*$F$2 This can be copied down to subsequent rows. Good Luck! Peter Moran |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Median calculation of grouped data. | Excel Worksheet Functions | |||
Data Calculation | Excel Discussion (Misc queries) | |||
DATA Calculation | Excel Discussion (Misc queries) | |||
How do I perform calculation on Filtered data | Excel Discussion (Misc queries) | |||
another data calculation | Excel Worksheet Functions |