View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Calculate the average of numbers, ignoring multiple values

I don't understand what you mean
do you want to ignore integers?
do you want to ignore multiples?
how do you identify what you want to ignore?

"Quintessence" wrote:

I understand how to calculate the average ignoring zero values, but I need to
ignore 0, 1, and 2 values.