Thread: how to calculate average value in a row ignoring values below "x"
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default how to calculate average value in a row ignoring values below "x"
=average(if(c8:c10025000,c8:c100))

Enter with Ctrl+Shift+Enter rather than Enter

"ed both" wrote:

i am trying to calculate the average of a column for values above 25000 using
following formula : =average(if(c8:c10025000,c8:c100,"")) but can't get it
working - any good ideas ? - thanks !!
Reply With QuoteReply With Quote