Prev: How to avoid the pop up message for updating links?
Next: extract data from a date range
From: Dante Mom Dante on 28 Mar 2010 22:07
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.
From: ozgrid.com on 28 Mar 2010 22:25
See this page;
http://www.ozgrid.com/Excel/formula-errors.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Dante Mom" <Dante Mom(a)discussions.microsoft.com> wrote in message
news:9CD7E384-6CD5-4971-A5F2-4C7FEE728EF1(a)microsoft.com...
>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.

From: Dante Mom on 28 Mar 2010 22:35
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.
From: Gary Keramidas on 28 Mar 2010 22:43
start deleting cells in this row to determine which cell is causing the
problem.

--


Gary Keramidas
Excel 2003


"Dante Mom" <DanteMom(a)discussions.microsoft.com> wrote in message
news:EA7FEA24-470B-461F-A652-930BB56C4CCB(a)microsoft.com...
> 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.

From: Ron Rosenfeld on 28 Mar 2010 22:43
On Sun, 28 Mar 2010 19:07:01 -0700, Dante Mom <Dante
Mom(a)discussions.microsoft.com> 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
 |  Next  |  Last
Pages: 1 2
Prev: How to avoid the pop up message for updating links?
Next: extract data from a date range