Thread: Calculate the average of numbers, ignoring multiple values
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
  
Posts: 3,268
Default Calculate the average of numbers, ignoring multiple values
I am assuming that you can't have negative values

=SUMIF(A2:A100,"2")/COUNTIF(A2:A100,"2")


--
Regards,

Peo Sjoblom




"Quintessence" wrote in message
...
I understand how to calculate the average ignoring zero values, but I need
to
ignore 0, 1, and 2 values.


Reply With QuoteReply With Quote