Sum Function Range
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.
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.
Please note: I reserve the right to delete comments that are offensive or off-topic.