Thread: how to calculate average value in a row ignoring values below "x"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ed both ed both is offline
external usenet poster
  
Posts: 1
Default how to calculate average value in a row ignoring values below "x"
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