Home |
Search |
Today's Posts |
#1
|
|||
|
|||
In excel the sum is not calculating
I am trying to add my column. It shows "o". I see I have numbers in the
column (these numbers are calculations from above rows) but when I hit add sum- it shows "0". When I hit = cell + cell + cell . . . (manually), it still shows "0" I have unprotected the document. How do I get my cell to calculate (cell d282) Add cells d260:281. Thank you. |
#2
|
|||
|
|||
Place curser in celld282.
Type =sum(d260:d281) or use the autosum function and drag it over desired cells anthony "Melody" wrote: I am trying to add my column. It shows "o". I see I have numbers in the column (these numbers are calculations from above rows) but when I hit add sum- it shows "0". When I hit = cell + cell + cell . . . (manually), it still shows "0" I have unprotected the document. How do I get my cell to calculate (cell d282) Add cells d260:281. Thank you. |
#3
|
|||
|
|||
Anthony,
I did use the autosum function and I tried the manual typing but it still shows "o". "Anthony" wrote: Place curser in celld282. Type =sum(d260:d281) or use the autosum function and drag it over desired cells anthony "Melody" wrote: I am trying to add my column. It shows "o". I see I have numbers in the column (these numbers are calculations from above rows) but when I hit add sum- it shows "0". When I hit = cell + cell + cell . . . (manually), it still shows "0" I have unprotected the document. How do I get my cell to calculate (cell d282) Add cells d260:281. Thank you. |
#4
|
|||
|
|||
Sorry Melody
whats in the other cells and and have you checked the format of all cells to check they are formated as general or number anthony "Melody" wrote: Anthony, I did use the autosum function and I tried the manual typing but it still shows "o". "Anthony" wrote: Place curser in celld282. Type =sum(d260:d281) or use the autosum function and drag it over desired cells anthony "Melody" wrote: I am trying to add my column. It shows "o". I see I have numbers in the column (these numbers are calculations from above rows) but when I hit add sum- it shows "0". When I hit = cell + cell + cell . . . (manually), it still shows "0" I have unprotected the document. How do I get my cell to calculate (cell d282) Add cells d260:281. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA for Excel 2000 file is corrupt | Excel Discussion (Misc queries) | |||
Excel Files Acting Weird | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |