QUESTION

Is it possible to add up the sum of two separate columns and get those two totals in a totally separate cell?

ANSWER

Well...yes!

Here is a formula that adds the sum of the first ten rows in columns A and B:

=SUM(A1:A10)+SUM(B1:B10)

This formula will add columns A and B no matter how many numbers there are in each column

=SUM(A:A)+SUM(B:B)