Spreadsheet will not return value of formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jmadden35@verizon.net - 18 Oct 2006 21:10 GMT

I have a spreadsheet that will not return the value of a formula. It
only states the formula.
If I have say a column of numbers A1 to A6 and put the formula
=sum(Aa1:Aa6) in A7 all that appears in A7 is the typed in formula not
the actual sum. If I copy the column of numbers to another sheet in the
workbook and put in the same formula I get back the actual sum????

Reply to this Message

Ed - 18 Oct 2006 21:31 GMT

In the offending workbook, check Tools >> Options, View tab, Window options
section, uncheck Formulas box.

Ed

>I have a spreadsheet that will not return the value of a formula. It
> only states the formula.
> If I have say a column of numbers A1 to A6 and put the formula
> =sum(Aa1:Aa6) in A7 all that appears in A7 is the typed in formula not
> the actual sum. If I copy the column of numbers to another sheet in the
> workbook and put in the same formula I get back the actual sum????

Reply to this Message

jmadden35@verizon.net - 20 Oct 2006 15:17 GMT

> In the offending workbook, check Tools >> Options, View tab, Window options
> section, uncheck Formulas box.
[quoted text clipped - 7 lines]
> > the actual sum. If I copy the column of numbers to another sheet in the
> > workbook and put in the same formula I get back the actual sum????

Thanks Ed that was the answer. Funny thing though, If I inserted a new
sheet into the
workbook that sheet did'nt have the problem??

Reply to this Message

Gord Dibben - 20 Oct 2006 23:23 GMT

That would be normal.

That setting is a Sheet setting, not a workbook or global setting.

Gord Dibben MS Excel MVP

>Thanks Ed that was the answer. Funny thing though, If I inserted a new
>sheet into the
>workbook that sheet did'nt have the problem??

Reply to this Message

Andrea Jones - 18 Oct 2006 21:34 GMT

Is it possible you've formatted that cell as text?

A Jones

> I have a spreadsheet that will not return the value of a formula. It
> only states the formula.
> If I have say a column of numbers A1 to A6 and put the formula
> =sum(Aa1:Aa6) in A7 all that appears in A7 is the typed in formula not
> the actual sum. If I copy the column of numbers to another sheet in the
> workbook and put in the same formula I get back the actual sum????

Reply to this Message

Rate this thread: