Still unsure of question but try
=COUNT(A1:A10)*8
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email


"Toey" wrote in message
...
Sorry for confusion. I want to be able to put the number 1 or 2 or 3 or 4
in
a cell and when i add the colum up each of those numbers woul = 8
ie. 1
2
_
16
"Bernard Liengme" wrote:

=1+2+3+4
but the answer is 10 not 8
Maybe we need the question reworded
Pease use the white space to ask it.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Toey" wrote in message
...