ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Subtracting (https://www.excelbanter.com/excel-worksheet-functions/134208-subtracting.html)

JS
Subtracting
 
How can I subtract a range of numbers from another number?

Mike
Subtracting
 
=A1-SUM(A2:A9)

Try that

"JS" wrote:

How can I subtract a range of numbers from another number?


All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com