View Single Post
  #1   Report Post  
Stephen
 
Posts: n/a
Default What cells in a array equal my value?

Hi all.

I have a column of cells that have many different values.

These values are numerical costs. ie 150.54, 5,541.00 ect

I have a numerical value that comprises of several of these cells added
together. However I do not know which ones need to be added to get the value
I'm looking for... Is there a function I can use that will take all the
cells and advise which ones need to be added to equal my value? I think this
might be a tough one..

Many thanks in advance Stephen.