ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   backwards sum (https://www.excelbanter.com/excel-programming/324200-backwards-sum.html)

choice[_2_]

backwards sum
 
i have a list of numbers in column A, and a value in B1.
is there a way to find if/what numbers in column A can add up to the value
in B1?

example Column A: 3,67,235,843,784,23,457647,1,4,235
B1: 305 (which would be 3+67+235)

hope that makes sense.
thanks in advance


All times are GMT +1. The time now is 10:39 AM.

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