Question

Book: Microsoft Excel 2013: Complete, pg EX 194, Part 3

I need help to understand how to put the formula in for question one. It reads "Enter a formula in cell C8 that divides the sum of cells C5 through C7 by cell C4. Write the formula so that when copied to cells D8:F8, Excel adjusts all the cell references according to the destination cells. Verify the formula..........."

=SUM(C5:C7)/C4 (i am almost positive this is not correct

Answer 1

Solution: I attached 2 snapshot here you can see that how is formula working as well. As given formula in question, this is correct. this is calculating sum of cell C5 :C7 and divided by C4 correctly. I copied this formula to C8:J8 and worked well. All calculations are correct. I think you need this only because you didn't mention any other problem.