Excel Question

K

kbrown1835

New Member
I have a spreadsheet that lists numerical values from say 1.03 - 4,339.75. There are 200 something values within the range. I need a formula that will show me the values that add up to a specific number. Say 1,625.93. There could be 2,3,4,5....or more numbers that may add up to this figure. Can anybody think of a way to do this. I would be satisfied for 2,3, or 4 number combinations. This is to assist a finance person with making journal entries.

Thanks.
 
OK

you type this into a cell

Code: 
=sum(*cells*)

in *cells* you select what cells you want to add up

Any other formulas you need???

Also in Office 2007 they do have the formulas there.
 
kbrown1835 said:
I have a spreadsheet that lists numerical values from say 1.03 - 4,339.75. There are 200 something values within the range. I need a formula that will show me the values that add up to a specific number. Say 1,625.93. There could be 2,3,4,5....or more numbers that may add up to this figure. Can anybody think of a way to do this. I would be satisfied for 2,3, or 4 number combinations. This is to assist a finance person with making journal entries.

Thanks.
Click to expand...

I'm not entirely sure what you mean... are you trying to say that, you have a list "X" of numbers, and you, from that list, want to be able to pick number combinations that add up to a specific number? e.g. you have a list with numbers 1-5 in it, you want a formula to spit out a number combinations that adds up to 12, and it gives you 5,4,and 3 (5+4+3=12, right?) If this is what you want it to do, I don't think there's a formula for it, however VBA can do that. If you don't know a thing about VBA or programming, then, well... if this indeed is your problem I can make a program to do it for you ;)
 
There is no simple solution to your problem because there is no 1 solution, there might be dozens. How could Excel know which one to choose?
 
You must log in or register to reply here.
Back
Top