Thread: Average Sum needs blank if no info
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
[email protected] conwaydawg@gmail.com is offline
external usenet poster
  
Posts: 3
Default Average Sum needs blank if no info
Got the answer right he

=IF(B3=0;0;AVERAGEA(B3;E3;H3))


Thanks guys!
Reply With QuoteReply With Quote