Formulae query

[Guest]

I use a very basic spreadsheet to record results at a show. The columns have
entrants names and the rows are the numbered events. Each event has 1st, 2nd
and 3rd places awarded and points for each place.

The number of entrants is 40 and the events 84 and at the end each entrant
has a points total. However each place in each event also has a different
monetary value. Is their any way that the place positions can be linked to
another sheet in the workbook so that I end up with each entrant having a
monetary value total as well as a points total?

 

[R..VENKATARAMAN]

as far as I undersood your quetion I think SUMPRODUCT would be useful . see
help on this function/formula
and also this url

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
==============

 

[Guest]

Many thanks for your advice, I shall give it a try.