Thread: Average If
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
--Viewpoint --Viewpoint is offline
external usenet poster
  
Posts: 21
Default Average If
Can someone provide a formula for the following:

If cells A1:A10 are greater than 0
Then Average A1:A10
Else (leave cell blank)


Reply With QuoteReply With Quote