Is it possible to use the summation operator ∑ in an excel formula?
L LizM Jul 10, 2006 #3 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.
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.
B Bob Phillips Jul 10, 2006 #4 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)
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)
