View Single Post
  #1   Report Post  
Jim
 
Posts: n/a
Default find parts of a total

I have 60 random numbers in a column of a spreadsheet. I know that 10 of
these numbers make up the sub total of a specific amount. If I know the
amount of the subtotal and know that 10 numbers sum to the sub total, how can
I have Excel extract or tell me which of the 60 random numbers sum to my sub
total?

Thanks, Jim