Excel Formula

portocat | 13:03 Fri 06th Jul 2007 | Technology

1 Answers

Does anyone know what formula to type into an excel spreadsheet to get it to subtract the total of several rows from one cell?

Thanks

Answers

Only 1 answer

Best Answer

No best answer has yet been selected by portocat. Once a best answer has been selected, it will be shown here.

This should do it:

=A1-SUM(B1:B4)

It will subtract the total of cells B1 to B4 from cell A1

Only 1 answer

Do you know the answer?