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.

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.

Newbie Qustion- how to divide sum of series by half?
 

HTH

Thanks for the reply - it does .

B.N.