Why is it important to check the range placed in the SUM function.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why is it important to check the range placed in the SUM function when using
the AutoSum button?
 
Sounds like homework!
1) Suppose your column of numbers is headed by a year (e.g. 2002), Excel
will include this.
2) Suppose =SUM(...) is used in the lower right of a block of numbers: will
Autosum add horizontally or vertically?

Please let me know what mark I got in the assignment

best wishes
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

autosum refusal to sum highlighted range 4
Autosum and formulas that result in text 4
How do I make AutoSum really Sum, not Subtotal 5
Autosum returns zero balance - why? 1
Autogroup then sum - can it be done? 5
IF AND Nested Functions - Formula Not Working 0
Auto Sum Function 3
Excel 2007 - sum function not working 2

Back
Top