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