See:

http://www.mcgimpsey.com/excel/accumulator.html

Regards,

Peo Sjoblom

"jim1022" wrote:

hi
i am trying to add up numbers in one extended cell,can this be done if so is
there a formula.
i cannot asign 1 cell per entry as this would make the spreadsheet too long
as it needs printing out afterwards
can anybody help???

jim