| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Average/Min column of numbers, but skip 0's and Null's in the form
Hello,
How do I average a column of numbers, but exclude cells that contain 0's or Null's? I don't want 0 figured into the average value. Secondly how do I find the MIN, but exclude 0's in the calculation? Thanks in advance. JT |
|
#2
|
|||
|
|||
|
Sorry for the triple post. I keep getting an error message after posting to
try again later. JT "JT" wrote: Hello, How do I average a column of numbers, but exclude cells that contain 0's or Null's? I don't want 0 figured into the average value. Secondly how do I find the MIN, but exclude 0's in the calculation? Thanks in advance. JT |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find AVG/MIN of a Column, excluding 0's and NULL's? | Excel Worksheet Functions | |||
Linear Mode
