| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulae query
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? -- Donbo |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulae query
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 ============== "Don" wrote in message ... 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? -- Donbo |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formulae query
Many thanks for your advice, I shall give it a try.
-- Donbo "R..VENKATARAMAN" wrote: 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 ============== "Don" wrote in message ... 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? -- Donbo |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems importing from an Access query | Excel Discussion (Misc queries) | |||
| changing query source | Excel Worksheet Functions | |||
| AHHH! Again | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
