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.
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.
=SUM(A1:A10)/2
will sum all values in A1 thru A10 and divide the result by 2.
HTH
--
AP
<[email protected]> a écrit dans le message de news:
[email protected]...
>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.
>HTH
Thanks for the reply - it does .
B.N.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks