| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summation Operator
Is it possible to use the summation operator ˆ‘ in an excel formula?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automate MTD summation | Excel Worksheet Functions | |||
| Customise the summation function / button | Excel Worksheet Functions | |||
| Using Concatenate operator to overcome 7 nested IF's | Excel Worksheet Functions | |||
| SaveAS to a specific folder, with operator input of file name | Excel Discussion (Misc queries) | |||
| "OR" operator to evaluate multiple conditions | Excel Worksheet Functions | |||
Linear Mode
