Possible sum in colunm of numbers

**Pedroluna** · 03-13-2009, 01:05 PM

Hi everyone,

I have an spreadsheet that has a colunm of numbers. I have three totals (values-no formula) that make up the total of that column. But i need to know which numbers make up each of those three totals. I was able to track one of the total but it was too time consuming. I know there are probably several different ways in wich this number can be add up. Is there a way to do this with a macro?

**tinyjack** · 03-13-2009, 01:13 PM

How long is your list? The number of combinations will build very quickly.
Do you have any negative numbers in your list?

TJ

**Pedroluna** · 03-13-2009, 02:17 PM

THe list is about 200 and yes there are negative numbers in it.
Thanks,

**tinyjack** · 03-13-2009, 02:44 PM

Is it possible for you to post a sample workbook, with the the list of numbers and the totals you are after?

TJ

ps I am about to tuck into my dinner, so might not look at this again until the morning