Thread: Average If (Value between 1 and 100)
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default Average If (Value between 1 and 100)
glad to help

--
Don Guillett
SalesAid Software

"DAI" <u29573@uwe wrote in message news:69d1ea8505130@uwe...
Thank you Don,

That worked great.

Don Guillett wrote:
This is an array formula which must be entered using ctrl+shift+enter

=AVERAGE(IF(ISNUMBER(E2:E200),E2:E200,""))

Hello,

[quoted text clipped - 19 lines]

Any Help would be appreciated.



Reply With QuoteReply With Quote