summing problem!!!!!!
 

hi all,
i have a problem i'll try to explain.

Example:I have formulas in cells a1 a2 and a3 which give a number as a
result.
In cell b1, i want to add the results from cells a1 a2 and a3 to give
me a total, eg,=sum(a1,a2,a3)
when i try this it just will not work, sometimes saying that the cell
is protected or something like that.
All the cells are on the same sheet.
Would appreciate any ideas and tips.

many thanks,

mark.


--
boufant
------------------------------------------------------------------------
boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725
View this thread: http://www.excelforum.com/showthread...hreadid=529049

summing problem!!!!!!
 

Tools/Protection/Unprotect Sheet

When sheet protection is activated it protects locked cells - so users can
input into unlocked cells, but are prevented from changing the locked cells
(Format/Cells/Protection - you'll see a checkbox for locking cells).

If your sheet is protected w/a password and you don't remember it, see
http://www.mcgimpsey.com/excel/removepwords.html


"boufant" wrote:


hi all,
i have a problem i'll try to explain.

Example:I have formulas in cells a1 a2 and a3 which give a number as a
result.
In cell b1, i want to add the results from cells a1 a2 and a3 to give
me a total, eg,=sum(a1,a2,a3)
when i try this it just will not work, sometimes saying that the cell
is protected or something like that.
All the cells are on the same sheet.
Would appreciate any ideas and tips.

many thanks,

mark.


--
boufant
------------------------------------------------------------------------
boufant's Profile: http://www.excelforum.com/member.php...o&userid=24725
View this thread: http://www.excelforum.com/showthread...hreadid=529049