| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems with offset/average formula
I am having trouble with the following formula:
=AVERAGE(OFFSET(A6,,COUNT(A6:W6)-10,,10)) . What I am trying to do is track one's 10 week rolling average golf score, where the scores are entered weekly in cells A6 thru W6. This works if I have at least 10 scores, but does not work if I have less than 10 scores. What do I need to do differently? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula problems: Some numbers don't add up right. | Excel Discussion (Misc queries) | |||
| Array Formula Limits (around 2800 or so) ? Lotus DSUM has no problems with it ! | Excel Discussion (Misc queries) | |||
| Match then lookup | Excel Worksheet Functions | |||
| Problems adding formula together. Please Help! | Excel Worksheet Functions | |||
| Am trying to make a time sheet and having problems with a formula. | Excel Worksheet Functions | |||
Threaded Mode
