Divide By help?
 

All,

I have a worksheet with 3 columns, as below

A B C D
1 f 23 21 5797
2 ff 54 545
3 sdf 54 434
4 dsfsd 645 11
5 dsfsd 6 21
6 sds 34 31
7 a 325 2
8 a 4565 13
9 w 7 13
10 e 34 1321
11 yt 23 2
12 ujty 2 13
13 hg 4 121
14 Total 5776


D1 is the following formula =sum(C1/B14)

I want to copy this formula for each row below, but keep it dividing by B14
(the total cell) e.g.

=sum(C2/B14)
=sum(C3/B14)
=sum(C4/B14)
=sum(C5/B14)

I can't work out how to do this, everytime i copy and paste it changes both
sections of the formula and i end up with

=sum(C2/B15)
=sum(C3/B16)
=sum(C4/B17)

This then gives me an error as these B cells are empty

Can someone offer help?

Kirstie

Divide By help?
 

Try:

=C2/$B$14

Don't know why you'd need "SUM"

Beege

kirstie adam wrote:
All,

I have a worksheet with 3 columns, as below

A B C D
1 f 23 21 5797
2 ff 54 545
3 sdf 54 434
4 dsfsd 645 11
5 dsfsd 6 21
6 sds 34 31
7 a 325 2
8 a 4565 13
9 w 7 13
10 e 34 1321
11 yt 23 2
12 ujty 2 13
13 hg 4 121
14 Total 5776


D1 is the following formula =sum(C1/B14)

I want to copy this formula for each row below, but keep it dividing by B14
(the total cell) e.g.

=sum(C2/B14)
=sum(C3/B14)
=sum(C4/B14)
=sum(C5/B14)

I can't work out how to do this, everytime i copy and paste it changes both
sections of the formula and i end up with

=sum(C2/B15)
=sum(C3/B16)
=sum(C4/B17)

This then gives me an error as these B cells are empty

Can someone offer help?

Kirstie

Divide By help?
 

what an easy answer, and am kicking myself because now i see it, it's
obvious!!
many thanks, works great,
kirstie

"Beege" wrote in message
. ..
Try:

=C2/$B$14

Don't know why you'd need "SUM"

Beege

kirstie adam wrote:
All,

I have a worksheet with 3 columns, as below

A B C D
1 f 23 21 5797
2 ff 54 545
3 sdf 54 434
4 dsfsd 645 11
5 dsfsd 6 21
6 sds 34 31
7 a 325 2
8 a 4565 13
9 w 7 13
10 e 34 1321
11 yt 23 2
12 ujty 2 13
13 hg 4 121
14 Total 5776


D1 is the following formula =sum(C1/B14)

I want to copy this formula for each row below, but keep it dividing by
B14
(the total cell) e.g.

=sum(C2/B14)
=sum(C3/B14)
=sum(C4/B14)
=sum(C5/B14)

I can't work out how to do this, everytime i copy and paste it changes
both
sections of the formula and i end up with

=sum(C2/B15)
=sum(C3/B16)
=sum(C4/B17)

This then gives me an error as these B cells are empty

Can someone offer help?

Kirstie