Finding cells

[Ìßìçò]

Hi i am looking for a function that will help me to find cells in a row,
which has different numpers (like A1 1.55,A2 2.31 A3 3.24, A5 2.67 A6
7.51.....) and the subtotal is a different cell (like B1 7.67)
Is there any way I can find from which cells is the cell B1 (exable
A1,A3,A5)
THANKS
Mimis K.

 

[Max]

Gathered what you want is find which cells in col A
will sum up to a certain total in B1.

Here's the links to 2 posts by MVP Tom Ogilvy
where he provides one solution using solver
and another programmatically

One solution using solver:
http://tinyurl.com/y4e7

Programmatic way:
http://tinyurl.com/y4eh

 

[Ìßìçò]

Thank you so much , Max

Mimis Karakousis
Thessaloniki , Greece

 

[Max]

you're welcome, Mimis !
Thanks for feedback

cheers
Max