How do I get a column to total only those that have a number result. I
realize that if I am dividing by 0 the answer is 0 but some of the
cells have a total and I can't get it to show those totals at the
bottom of the column.  Unless they are all filled in I get the #div/0
message in the total column. It is probably pretty simple if it can be
done.

I read it three times, and frankly, I can't understand what you're asking.

Are you trying to add cells that have #div/o in them?

In column A there is formula (no numbers have been entered at this
time - just a formula) in column B there is a formula (no numbers have
been entered at this time - just a formula).  What I am doing is
putting a formula in column C  to divide B by A.  Because there is no
entry yet - just a formula I get the message #div/o.  I am doing an
inventory spreadsheet and eventually numbers will be added to these
columns.  Not all columns will have entries every month.  What I need
to do is to total the columns and have them only add the columns that
have numbers in them.  A total does not show up because there is not a
number in all of the columns.  Is there a way to get these numbers to
total even though not all the columns are filled?

Basically yes I am trying to add columns with #div/0 in them.  Not all
cells will have an entry therefore a total will not show.
Thank you

>A total does not show up because there is not a
number in all of the columns.

You're try to make me read your mind.  I'm afraid you're still not
explaining it well.  You 'should be' getting totals in columns A and
B, even though there are no entries in some of your cells.  Open a
'test' worksheet.  In Cell A1, enter 1.  Leave Cell B1 blank
(emulating your no entry cells).  In Cell C1, enter 2.  In Cell D1,
put =SUM(A1:C1).  The formula calculates 3, right?  Excel interprets
the blank as zero (0).

Let's move onto your #div/0.  If Excel interprets a blank as zero,
then its trying to divide by zero.  There is no such thing.  So Excel
gets all confused, doesn't know what to do, and puts #div/0?  What you
need to do is to put a conditional formula so that if it is blank, you
tell it not to do the division.

In column C1, put the formula =IF(A1="","",B1/A1).

Leave Column A1 blank, as in your inventory spreadsheet.  Excel will
put nothing, instead of #div/0.  Now put some values in Cells A1 and
B2.  It will now do the division requested.

You are probably trying to sum or process a few cells that are the
result of other caculations (division). If the division fails you get
a #div/0 error and the cells can't be processed.

Try this in each cell that has an #div/0 error
 =if(iserror(a10/b10),0,(a10/b10))

It reads if you find an error in calculation (a10/b10) or whatever
your calculation is then put a zero 0 if not do the calculation
(a10/b10).

Cheers Rob.