Array Function - cell to remain blank

I am a novice on Excel, however, I don't get easy projects.

I have a spreadsheet where D615 have values. In cell D17
is the Total, which is an average of what exists in D615.
However, some of these cells have zero value, so this was
taken into consideration when building the formula for D17.

This is the formula: {=AVERAGE(IF(D6150,D615,""))}

Right now, there are no values in D615 (nothing to input
yet), but in cell D17 is the message: #DIV/0!.

I've tried to see if I can fix the above array formula,
but I'm making it worse.

How do I get D17 (Total) to be empty when there is nothing
(yet) in D615?

Any suggestions will be helpful. Thank you.

Good afternoon -

In D17, you need to add to your formula.
Try this:

=If(Iserror(Average(If(D6150,D615))),0,Avera ge(If(D6150,D615)))
If you want it to be BLANK the Use "" Double Quote Double Quote instead of Zero.
=If(Iserror(Average(If(D6150,D615))),"",Aver age(If(D6150,D615)))


Be sure to enter as an Array formula.


Thanks,
Jon Barchenger
--------------------
| **Content-Class: urn:content-classes:message
| **From: "mare"
| **Sender: "mare"
| **Subject: Array Function - cell to remain blank
| **Date: Mon, 10 Nov 2003 07:03:41 -0800
| **Lines: 19
| **Message-ID:
| **MIME-Version: 1.0
| **Content-Type: text/plain;
| ** charset="iso-8859-1"
| **Content-Transfer-Encoding: 7bit
| **X-Newsreader: Microsoft CDO for Windows 2000
| **X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| **Thread-Index: AcOnm9Pxow4nwK7BQICubRH21ndZTQ==
| **Newsgroups: microsoft.public.excel.worksheet.functions
| **Path: cpmsftngxa06.phx.gbl
| **Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.worksheet.functions:170271
| **NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| **X-Tomcat-NG: microsoft.public.excel.worksheet.functions
| **
| **I am a novice on Excel, however, I don't get easy projects.
| **
| **I have a spreadsheet where D615 have values. In cell D17
| **is the Total, which is an average of what exists in D615.
| **However, some of these cells have zero value, so this was
| **taken into consideration when building the formula for D17.
| **
| **This is the formula: {=AVERAGE(IF(D6150,D615,""))}
| **
| **Right now, there are no values in D615 (nothing to input
| **yet), but in cell D17 is the message: #DIV/0!.
| **
| **I've tried to see if I can fix the above array formula,
| **but I'm making it worse.
| **
| **How do I get D17 (Total) to be empty when there is nothing
| **(yet) in D615?
| **
| **Any suggestions will be helpful. Thank you.
| **