determine which values in a range of cells make up a given total

[Sheri Beri]

I wish to find which cells in a range of data add up to a predetermined value.

 

[Héctor Miguel]

hi, Sheri !

I wish to find which cells in a range of data add up to a predetermined value.

following is in spanish, but I guess you might want to give a try (?)

http://www.teladearana.es/seccion/excel/137-localizar-sumas.html

two versions (each with downloadable workbooks):
- a vba procedure using solver
- an UDF (based on Jimmy L. Day algorithm: -> http://tinyurl.com/3qglnn)

hth,
hector.

 

[Gary''s Student]

See:

http://www.tushar-mehta.com/excel/templates/match_values/index.html