If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ . |
#2
|
|||
|
|||
AVERAGE of row gives no result
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 |
#3
|
|||
|
|||
AVERAGE of row gives no result
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/ |
#4
|
|||
|
|||
AVERAGE of row gives no result
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! |
#5
|
|||
|
|||
AVERAGE of row gives no result
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/ |
#6
|
|||
|
|||
AVERAGE of row gives no result
TO DDM:
No, the font color is set to 'Automatic'/black. Any other ideas? --- Message posted from http://www.ExcelForum.com/ |
#7
|
|||
|
|||
AVERAGE of row gives no result
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/ |
#8
|
|||
|
|||
AVERAGE of row gives no result
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 |
#9
|
|||
|
|||
AVERAGE of row gives no result
"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 |
#10
|
|||
|
|||
AVERAGE of row gives no result
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/ |
|
Thread Tools | |
Display Modes | |
|
|