Sum range in Excel

  • Thread starter Thread starter Aidan
  • Start date Start date
A

Aidan

If you have numbers in a range say B4:B7 and the last row is blank, should
the function read =SUM(B4:B8) to include the blank row or ius it ok to leave
it at =SUM(B4:B7). A colleague who works in this area insists it is good
practice to use the first option. Any thoughts appreciated.

Aidan.
 
I would use B4:B8, in case anyone inserts a row at row 8 and adds a value,
it will automatically get added.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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

Excel Complex Summing 3
Mixed references 2
Autofiller Tool Help 3
Define variable range input for SUM() function 8
How to do this with macro? 2
Averageifs - criteria is cell is not blank 1
How Do I calculate this? 5
Trouble flagging conditions in Excel using VB 6

Back
Top