| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
Thanks! That worked great too...
"Jason Morin" wrote: One way: =SUM(A2:A20)/COUNTIF(A2:A20,"<0") HTH Jason Atlanta, GA -----Original Message----- I use a spreadsheet in a fantasy racing league. I would like to show what the player's weekly average score is, but I want to ignore future races (current values are 0). Am I making this more difficult than it really is? . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I lookup values from rows and columns Simultaneously | Excel Worksheet Functions | |||
| How to copy values in various rows automatically | Excel Discussion (Misc queries) | |||
| Formula to compare multiple rows values based on another column? | Excel Worksheet Functions | |||
| Lookup values in a list and return multiple rows of data | Excel Worksheet Functions | |||
| Identifying exact values in alternate rows | Excel Worksheet Functions | |||
Threaded Mode
