I am using a very easy formula to add certain numbers across a spreadsheet.
It has worked fine for each line until I reached one line where the formula
doesn't work - Even though I have the formula as sum of certain functions on
that line (as I do in other lines of the spreadsheet), I get the sum of
numbers in this column added down to this line. And the lines after this
particular again use my formula. It is making me craxy.

See this page;
http://www.ozgrid.com/Excel/formula-errors.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Dante Mom" <Dante wrote in message
...
I am using a very easy formula to add certain numbers across a spreadsheet.
It has worked fine for each line until I reached one line where the
formula
doesn't work - Even though I have the formula as sum of certain functions
on
that line (as I do in other lines of the spreadsheet), I get the sum of
numbers in this column added down to this line. And the lines after this
particular again use my formula. It is making me craxy.

Thank you for your suggestion but there is no problem with the formula (it
works on all the other lines) but for some reason it does not work on this
line.

"Dante Mom" wrote:

I am using a very easy formula to add certain numbers across a spreadsheet.
It has worked fine for each line until I reached one line where the formula
doesn't work - Even though I have the formula as sum of certain functions on
that line (as I do in other lines of the spreadsheet), I get the sum of
numbers in this column added down to this line. And the lines after this
particular again use my formula. It is making me craxy.

start deleting cells in this row to determine which cell is causing the
problem.

--


Gary Keramidas
Excel 2003


"Dante Mom" wrote in message
...
Thank you for your suggestion but there is no problem with the formula (it
works on all the other lines) but for some reason it does not work on this
line.

"Dante Mom" wrote:

I am using a very easy formula to add certain numbers across a
spreadsheet.
It has worked fine for each line until I reached one line where the
formula
doesn't work - Even though I have the formula as sum of certain functions
on
that line (as I do in other lines of the spreadsheet), I get the sum of
numbers in this column added down to this line. And the lines after this
particular again use my formula. It is making me craxy.

Does that row contain an error?



--
Regards
Dave Hawley
www.ozgrid.com
"Dante Mom" wrote in message
...
Thank you for your suggestion but there is no problem with the formula (it
works on all the other lines) but for some reason it does not work on this
line.

"Dante Mom" wrote:

I am using a very easy formula to add certain numbers across a
spreadsheet.
It has worked fine for each line until I reached one line where the
formula
doesn't work - Even though I have the formula as sum of certain functions
on
that line (as I do in other lines of the spreadsheet), I get the sum of
numbers in this column added down to this line. And the lines after this
particular again use my formula. It is making me craxy.

On Sun, 28 Mar 2010 19:07:01 -0700, Dante Mom <Dante
wrote:

I am using a very easy formula to add certain numbers across a spreadsheet.
It has worked fine for each line until I reached one line where the formula
doesn't work - Even though I have the formula as sum of certain functions on
that line (as I do in other lines of the spreadsheet), I get the sum of
numbers in this column added down to this line. And the lines after this
particular again use my formula. It is making me craxy.

Hard to tell without knowing the formula, data, actual and expected outputs.

Or at least an example of all of that so we can try to reproduce the problem.
--ron