AVERAGE of row gives no result

cells are formatted as text?

-----Original Message-----
This problem MUST have a really simple answer; I just
don't know what it
is...
When I attempt to average the values in one particular
row on my
worksheet, there is never any result given! The 'average'
function
works everywhere else in the sheet (on other rows and
columns, etc) but
in this one row, after entering the correct syntax
(=average(range)),
then clicking on Enter, the cursor moves on but leaves no
result behind
(??????)
POSSIBLE CLUE: The values in the 'problem row' are all
the result of an
"IF(SUM)"-type formula.
Any help on this would be appreciated [:-) I've never had
any problem
before with 'average' worksheet function, so this has me
kind of
weirded-out!

riprap.


---
Message posted from http://www.ExcelForum.com/

.

On Sun, 2 May 2004 11:31:34 -0500, turtleman2
wrote:

When I attempt to average the values in one particular row on my
worksheet, there is never any result given!

What does that mean?

Is the cell blank?
Does the cell display the formula?
Does the cell show a 0?

If the cell appears blank, what is the format of the cell? And exactly what is
your formula within the cell.


--ron

Just because it is formatted as number does not mean it is a number.

Copy an empty cell which is formatted as number or general.

Select the row and Paste SpecialAddOKEsc.

Try your AVERAGE again.

Gord Dibben Excel MVP

On Sun, 2 May 2004 12:36:13 -0500, turtleman2
wrote:

No--I checked that. The entire row's formatted as 'Number', with 2
decimal places.
Any other ideas?


---
Message posted from http://www.ExcelForum.com/

Is the formula still in the cell?

If not, you may have an event macro deleting the formula.

If so, check for conditional formatting that would change the font color.

Do other fuctions (e.g., =SUM(rng) ) work?

In article ,
turtleman2 wrote:

This problem MUST have a really simple answer; I just don't know what it
is...
When I attempt to average the values in one particular row on my
worksheet, there is never any result given! The 'average' function
works everywhere else in the sheet (on other rows and columns, etc) but
in this one row, after entering the correct syntax (=average(range)),
then clicking on Enter, the cursor moves on but leaves no result behind
(??????)
POSSIBLE CLUE: The values in the 'problem row' are all the result of an
"IF(SUM)"-type formula.
Any help on this would be appreciated [:-) I've never had any problem
before with 'average' worksheet function, so this has me kind of
weirded-out!

Is the font color for that cell set to "white?"
--
DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com


"turtleman2 " wrote in message
...
This problem MUST have a really simple answer; I just don't know what it
is...
When I attempt to average the values in one particular row on my
worksheet, there is never any result given! The 'average' function
works everywhere else in the sheet (on other rows and columns, etc) but
in this one row, after entering the correct syntax (=average(range)),
then clicking on Enter, the cursor moves on but leaves no result behind
(??????)
POSSIBLE CLUE: The values in the 'problem row' are all the result of an
"IF(SUM)"-type formula.
Any help on this would be appreciated [:-) I've never had any problem
before with 'average' worksheet function, so this has me kind of
weirded-out!

riprap.


---
Message posted from http://www.ExcelForum.com/

TO DDM:
No, the font color is set to 'Automatic'/black.
Any other ideas?


---
Message posted from http://www.ExcelForum.com/

If you select the cell with the formula, then in the formula bar use the
mouse to highlight this part

COUNTA(AM$3:AM$48)=7

then press F9, what do you get? If you get FALSE the formula returns the
correct result,

Try just using this

=SUM(AM$3:AM$48)

do you get a result now?

--

Regards,

Peo Sjoblom

"turtleman2 " wrote in message
...
TO DDM:
No, the font color is set to 'Automatic'/black.
Any other ideas?


---
Message posted from http://www.ExcelForum.com/

On Sun, 2 May 2004 13:41:20 -0500, turtleman2
wrote:

TO Ron Rosenfeld:
When I say "there is never any result given", I mean that after I
click on Enter [to execute the Average function] and the cursor moves
on, the cell containing the Average appears blank. No zero, no error
msge, no anything. If I go back to that cell and select it, my Average
formula appears up on the Formula bar just fine, but there's no result
in the cell.


Check these three things:

Select the cell with the AVERAGE formula that shows blank.
Put your cursor in the formula bar and F9. What shows up?

Then select (from the menu bar): Format/Conditional Formatting
Is there anything set?

Select Tools/Options/View Window Options
Is "Zero Values" checked?


--ron

"Ron Rosenfeld" wrote in message
...
On Sun, 2 May 2004 13:41:20 -0500, turtleman2
wrote:

TO Ron Rosenfeld:
When I say "there is never any result given", I mean that after I
click on Enter [to execute the Average function] and the cursor moves
on, the cell containing the Average appears blank. No zero, no error
msge, no anything. If I go back to that cell and select it, my Average
formula appears up on the Formula bar just fine, but there's no result
in the cell.


Check these three things:

Select the cell with the AVERAGE formula that shows blank.
Put your cursor in the formula bar and F9. What shows up?

Then select (from the menu bar): Format/Conditional Formatting
Is there anything set?

Select Tools/Options/View Window Options
Is "Zero Values" checked?



Hi Ron,

I also thought about the zero values, that could explain things, all values
are
text and thus the formula returns zero and result won't be displayed
If this is numbers imported from the web and there are trailing char(160)
then the coercion using adding
zero or multiplying with 1 won't work




--

Regards,

Peo Sjoblom

Discovery:
I've found out that, if I go to ToolsOptionsCalculation, and change
the setting under Calculation from "Automatic" to "Manual", w/
"Recalculate before save" checked, that now the average formula works
perfectly.

But that's the first time I've ever had to change that setting.
Why does that setting being changed cause things to work?

Thanks again for your time [:-)

riprap.


---
Message posted from http://www.ExcelForum.com/