| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average Cells above 0
Hi Everone! I'm trying to average a group of cells, but only the cells over 0.
I tried this - =average(if(i2515:i5043)0,i2515:i5043)). I also entered it as an array but it still didn't work. Please help! -- Thanks! Stephen |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locking a formula to cells | Excel Discussion (Misc queries) | |||
| Limit or Exclude cells in Average and Sum formula | Excel Worksheet Functions | |||
| Average form cells containing formulas? | Excel Worksheet Functions | |||
| How do i get an average that ignores blanks in the range of cells. | Excel Worksheet Functions | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Threaded Mode
