Formula Result does not Equal cell value

KalleeP

Board Regular
Joined
Nov 4, 2002
Messages
67
Hi All

I have a strange problem, Excel 2003. Its a simple formula, =COUNTA(E7:E16) however for some reason it does not work (nor will the formula work any where on the sheet). If you click on the Function insert the Formula Result does actually have the correct result, but the value in the cell does not change. There is an error saying that the formula refers to empty cells, which it obviously would???

When i sent the spreadsheet to another computer with excel 2007, everything worked fine. This leads me to believe that the problem is in the excel 2003 settings, but I can not figure it out for the life of me.

Anyone run into this problem before?

**Edit** F9 doesn't work, auto calc is on

Thanks

Kallee
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Gerald Higgins

Well-known Member
Joined
Mar 26, 2007
Messages
9,115
What are the values in the range E7:E16?
Should be easy to list them all for us . . .
 

KalleeP

Board Regular
Joined
Nov 4, 2002
Messages
67
E7 = x
E8 = k

Otherwise it is blank, I highlighted and cleared the blank rows to be sure. The cells are not formatted as text, so no luck there.

The formulas work, as i can see the proper result, but they just wont display in the cell. I have tried other formula's doing a =countif(E7:E56,"*"), tried it on different columns, different rows.

thanks
 

Watch MrExcel Video

Forum statistics

Threads
1,122,518
Messages
5,596,622
Members
414,082
Latest member
sasmita

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top