how would I write a formula
 

how would I write a formula for cell B8 that divides cell D5 by the sum of
cells N10 through N13, write the formula so that when it is copied to cell C8
and D8, cell D5 remains absolute?

how would I write a formula
 

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lisa" wrote in message
...
how would I write a formula for cell B8 that divides cell D5 by the sum of
cells N10 through N13, write the formula so that when it is copied to cell
C8
and D8, cell D5 remains absolute?

how would I write a formula
 

yeah

"Don Guillett" wrote:

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lisa" wrote in message
...
how would I write a formula for cell B8 that divides cell D5 by the sum of
cells N10 through N13, write the formula so that when it is copied to cell
C8
and D8, cell D5 remains absolute?

how would I write a formula
 

On 9 Feb, 16:14, Lisa wrote:
how would I write a formula for cell B8 that divides cell D5 by the sum of
cells N10 through N13, write the formula so that when it is copied to cell C8
and D8, cell D5 remains absolute?

In B8 type:-

=$D$5/SUM(N10:N13)

The $ (Dollar) symbol before the column and row parts of the cell
reference D5 ensure that that remains absolute as you want. N10:N13
will remain relative.

Hope this helps,
Matt Richardson
http://teachr.blogspot.com

how would I write a formula
 

Lisa

The purpose of home work is to learn not to provide the answer. Tell us
what you have tried, what worked and what did not work. Tell us where you
have looked and what you do or do not understand. Show us some effort and we
will direct you in this LEARNING process. Help us help you!

Mike Rogers

"Lisa" wrote:

yeah

"Don Guillett" wrote:

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lisa" wrote in message
...
how would I write a formula for cell B8 that divides cell D5 by the sum of
cells N10 through N13, write the formula so that when it is copied to cell
C8
and D8, cell D5 remains absolute?

how would I write a formula
 

thanks matt, I put a hyphen where the colon should of been and i didn't place
a dollar sign in front of the five...thanks for your help


"Matt Richardson" wrote:

On 9 Feb, 16:14, Lisa wrote:
how would I write a formula for cell B8 that divides cell D5 by the sum of
cells N10 through N13, write the formula so that when it is copied to cell C8
and D8, cell D5 remains absolute?

In B8 type:-

=$D$5/SUM(N10:N13)

The $ (Dollar) symbol before the column and row parts of the cell
reference D5 ensure that that remains absolute as you want. N10:N13
will remain relative.

Hope this helps,
Matt Richardson
http://teachr.blogspot.com

how would I write a formula
 

I'm with you on this

"Mike Rogers" wrote:

Lisa

The purpose of home work is to learn not to provide the answer. Tell us
what you have tried, what worked and what did not work. Tell us where you
have looked and what you do or do not understand. Show us some effort and we
will direct you in this LEARNING process. Help us help you!

Mike Rogers

"Lisa" wrote:

yeah

"Don Guillett" wrote:

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lisa" wrote in message
...
how would I write a formula for cell B8 that divides cell D5 by the sum of
cells N10 through N13, write the formula so that when it is copied to cell
C8
and D8, cell D5 remains absolute?

how would I write a formula
 

On 9 Feb, 22:40, Jeremy <jeremiah.a.reynolds @ gmail.com wrote:
I'm with you on this

"Mike Rogers" wrote:
Lisa

The purpose of home work is to learn not to provide the answer. Tell us
what you have tried, what worked and what did not work. Tell us where you
have looked and what you do or do not understand. Show us some effort and we
will direct you in this LEARNING process. Help us help you!

Mike Rogers

"Lisa" wrote:

yeah

"Don Guillett" wrote:

Homework?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lisa" wrote in message
...
how would I write a formula for cell B8 that divides cell D5 by the sum of
cells N10 through N13, write the formula so that when it is copied to cell
C8
and D8, cell D5 remains absolute?

I also agree with the guys here. I posted my response before Id seen
that it was definitely homework. Whilst Im glad I helped I would
definitely recommend that rather than just followin g the instructions
I posted you try and understand WHY it works.

Regards,
Matt Richardson
http://teachr.blogspot.com