software

I have a range of cells that I need to total. Problem is many of these cells
currently contain formulas that have an #N/A value in them because they are
included in a graph and I don't want to plot them until monthly data is
entered during the year.
How can I total the cells that have a numerical value and ignore those that
still have an #N/A ?

On Mon, 13 Feb 2006 08:32:05 -0800, quot;JDquot; gt; wrote:

gt;I have a range of cells that I need to total. Problem is many of these cells
gt;currently contain formulas that have an #N/A value in them because they are
gt;included in a graph and I don't want to plot them until monthly data is
gt;entered during the year.
gt;How can I total the cells that have a numerical value and ignore those that
gt;still have an #N/A ?

The **array** formula:

=SUM(IF(ISNUMBER(rng),rng))

To enter an **array** formula, hold down lt;ctrlgt;lt;shiftgt; while hitting lt;entergt;.
Excel will place braces {...} around the formula

--ron

One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=SUM(IF(ISNUMBER(rng),rng))

In article gt;,
quot;JDquot; gt; wrote:

gt; I have a range of cells that I need to total. Problem is many of these cells
gt; currently contain formulas that have an #N/A value in them because they are
gt; included in a graph and I don't want to plot them until monthly data is
gt; entered during the year.
gt; How can I total the cells that have a numerical value and ignore those that
gt; still have an #N/A ?