ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need a Formula (https://www.excelbanter.com/excel-worksheet-functions/52400-need-formula.html)

sunrosejenn

Need a Formula
 
B2 has a $ amount in it
B4 through B35 has payment amounts in it


B2 minus B4 thru B35 = B36 this is what I need a formula for. Thanks

Anne Troy

Need a Formula
 
=b2-sum(b4:b35)
************
Anne Troy
www.OfficeArticles.com

"sunrosejenn" wrote in message
...
B2 has a $ amount in it
B4 through B35 has payment amounts in it


B2 minus B4 thru B35 = B36 this is what I need a formula for. Thanks




sunrosejenn

Need a Formula
 
Thank You!!!



"Anne Troy" wrote:

=b2-sum(b4:b35)
************
Anne Troy
www.OfficeArticles.com

"sunrosejenn" wrote in message
...
B2 has a $ amount in it
B4 through B35 has payment amounts in it


B2 minus B4 thru B35 = B36 this is what I need a formula for. Thanks





Anne Troy

Need a Formula
 
You're quite welcome!
************
Anne Troy
www.OfficeArticles.com

"sunrosejenn" wrote in message
...
Thank You!!!



"Anne Troy" wrote:

=b2-sum(b4:b35)
************
Anne Troy
www.OfficeArticles.com

"sunrosejenn" wrote in message
...
B2 has a $ amount in it
B4 through B35 has payment amounts in it


B2 minus B4 thru B35 = B36 this is what I need a formula for. Thanks








All times are GMT +1. The time now is 11:18 AM.

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