# Is the sheet blocked?

#### Fahsid1230

##### Active Member
Hi Folks,
I 'm doing a very simple summation that is:
\$81,919
17,916
206,248
by using =sum(a1:a3)
but every time I hit enter, I get 0 instead of \$306,083. Any security problem or unknown blocakge which I'm not aware off?
Any help will be appreciated.
thx

### Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

#### ExcelChampion

##### Well-known Member
Are the numbers actually text?

What do you get with =A1+A2+A3 ?

#### Fahsid1230

##### Active Member
no there are not. I checked the format of each cell.

#### ExcelChampion

##### Well-known Member
Checking the format of each cell does not necessarily reveal that the numbers are actually text.

What do you get with:

=ISNUMBER(A1)

#### Fahsid1230

##### Active Member
Infact, this hseet which I'm wroking on, has the formulas and calc, but the moment I mimic the same, its turns to 0. seems like some security check is ther.
Any suggestion or help will be greatly appreciated.
Thx

#### ExcelChampion

##### Well-known Member
You have not answered either of my questions. I cannot help further with out the information I asked for.

#### Fahsid1230

##### Active Member
when I did that =ISNUMBER(A1)...it say TRUE.

#### Fahsid1230

##### Active Member
and when I did A1+A2+A3 the result is still the same \$0.

#### Fahsid1230

##### Active Member
Todd, I answered both of your question.
Any suggestion?

#### Fahsid1230

##### Active Member
Folk,
infact, any refrence, any summation, multiplication, addition, subtraction is given out the resuly 0. Any suggestion why the sheet is acting like that?

Replies
6
Views
1K
Replies
4
Views
231
Replies
6
Views
276
Replies
25
Views
471
Replies
20
Views
697

1,191,165
Messages
5,985,034
Members
439,935
Latest member
Monty238

### 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?

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