DATA CALCULATION

[Guest]

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

 

[Don Guillett]

more info?

 

[pmor1945]

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