Summation Operator
 

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

Summation Operator
 

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

--
Don Guillett
SalesAid Software

"LizM" wrote in message
...
Is it possible to use the summation operator ? in an excel formula?

Summation Operator
 

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.

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"LizM" wrote in message
...
Is it possible to use the summation operator ? in an excel formula?

Summation Operator
 

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)

"LizM" wrote in message
...
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.

"Don Guillett" wrote:

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

--
Don Guillett
SalesAid Software

"LizM" wrote in message
...
Is it possible to use the summation operator ? in an excel formula?