| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Newbie Qustion- how to divide sum of series by half?
I need to enter a formula which divides the sum of a series of numbers
by 2 so that I can compare this to another set of figures. What is the formula which will , initially , add a series of numbers and then divide them by 2 , please/ B.N. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Newbie Qustion- how to divide sum of series by half?
=SUM(A1:A10)/2
will sum all values in A1 thru A10 and divide the result by 2. HTH -- AP a écrit dans le message de news: ... I need to enter a formula which divides the sum of a series of numbers by 2 so that I can compare this to another set of figures. What is the formula which will , initially , add a series of numbers and then divide them by 2 , please/ B.N. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Newbie Qustion- how to divide sum of series by half?
HTH Thanks for the reply - it does . B.N. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to change ColorIndex for series settings | Charts and Charting in Excel | |||
| Chart -- Source Data... -- Series dialog window | Charts and Charting in Excel | |||
| Newbie needs help with incrementing a series of cells | Excel Worksheet Functions | |||
| How to change Series order in a Combination Chart? | Charts and Charting in Excel | |||
| series graph -- one series being added to another series | Charts and Charting in Excel | |||
Linear Mode
