Sum entire column or row

To sum entire column or row use the SUM function with the relevant column or row reference e.g. for the entire sum of column B, use =SUM(B:B) formula.

Excel recognized full column or row reference like this:

=SUM(B:B) means the entire sum of column B

=SUM(7:7) means the entire sum of row 7

Caution

Although,  the ‘Sum entire column’ or row is a useful way to save time and add all data, however, extra data like dates etc. may include and create difficulties.

Copyright © 2016 - 2018 Explainry.com | All Rights Reserved