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.

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