formula error

D

Dante Mom

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.
 
D

Dante Mom

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.
 
G

Gary Keramidas

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

Ron Rosenfeld

On Sun, 28 Mar 2010 19:07:01 -0700, Dante Mom <Dante
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top