Sum range in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aidan - 05 Feb 2008 09:30 GMT

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.

Reply to this Message

Bob Phillips - 05 Feb 2008 09:45 GMT

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

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> 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
[quoted text clipped - 3 lines]
>
> Aidan.

Reply to this Message