| Home |
| Search |
| Today's Posts |
|
#3
|
|||
|
|||
=SUMIF(C5:C127,"0.00")/COUNTIF(C5:C127,"0.00")
"Lori Burton" wrote: I'm looking for a way to get the average of numbers in a column that meet a certain critiera. For instance, in one column, I will have numbers ranging from 1 thru 6. I am not interested in having the number 6 averaged into the total. (In essence 6 is assigned through an option button that really should be 0 and I don't want zeros included as part of my averaging) -- Lori |
Threaded Mode
