Thread: average formula ingoring empty cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jenparker1234 jenparker1234 is offline
external usenet poster
  
Posts: 1
Default average formula ingoring empty cells

I need to create a formula to average several cells, but the cells are
not in a range.

So far I have =AVERAGE(G3, J3, M3, P3, S3), which works fine, but cells
M3,
P3 and S3 are empty (zero) until I have the data that I need. I want
the formula to already be set up for future input.

I've been able to make it work for a range of values (G3:S3), but not
with indivual cells in a group.

Help please! Thanks. :)


--
jenparker1234
------------------------------------------------------------------------
jenparker1234's Profile: http://www.excelforum.com/member.php...o&userid=36266
View this thread: http://www.excelforum.com/showthread...hreadid=560539

Reply With QuoteReply With Quote