Technology Support - Excel

In this first example, we will add cells A1 (25) and A3 (45).

The formula to this is "=sum(first_cell, second_cell)" (quotation marks not used)

In this screenshot we can see the result of adding cells A1 and A3

In the second example we will add cells A1 through A4.

The formula to do this is "=sum(first_cell:last_cell)" (quotation marks not used)

In this screenshot we can see the result of adding cells A1 through A4

In this example we will start with cell A1 (160) and subtract cells A2, A3, and A4.

The formula to do this is "=(A1-A2-A3-A4)" (quotation marks not used)

In this screenshot we can see the result of subtracting cells A2, A3 & A4 from cell A1.