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)
 
Back
Top