The SUM function can handle more than one range eg
Instead of
=SUM(A1:A100)+SUM(C1:C100)
Use
=SUM(A1:A100,C1:C100)
will total both ranges.
Sum Function Range
- Post author:Neale Blackwood
- Post published:29/09/2014
- Post comments:0 Comments
- Reading time:1 min read