Summation Operator

[Guest]

Is it possible to use the summation operator ∑ in an excel formula?

 

[Don Guillett]

AFAIK-No
Is there a problem with
=sum(a1:z1)

 

[Guest]

Yes. I was hoping to sum a calculation for n=10 observations or n=20. Each
row has a different total number of observations and I did not want to have a
row for each and sum.

Do you know of an easier way?

Thanks.

 

[Bob Phillips]

if you do =SUM(A1:Ax) where x is the largest possible number, if will work
okay, even if some cells are empty.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)