formula for adding / subtracting two columns .

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jm - 24 May 2006 08:21 GMT

Can't find formula to add or subtract two or three entire columns in a spread
sheet
Thank you

Reply to this Message

Gary''s Student - 24 May 2006 09:54 GMT

Let's say we have numbers in two columns, column A and column B from rows 1
thru 100.

In C1, enter:
=A1+B1 and copy down thru C100

Column C will be the sum of columns A & B.

To get the grand sum of columns A & B in a single cell, enter in an un-used
cell:
=SUM(A1:B100)

Signature

Gary''s Student

> Can't find formula to add or subtract two or three entire columns in a spread
> sheet
> Thank you

Reply to this Message

Andy - 24 May 2006 10:50 GMT

Hi
Try something like:
=SUM(A:A)-SUM(B:B)-SUM(C:C)

Andy.

> Can't find formula to add or subtract two or three entire columns in a
> spread
> sheet
> Thank you

Reply to this Message