find specifc total among group of cells with numbers

[Monelle]

Using Excel 2003, is there a way to find a specific total among a group of numbers in cells? Let’s say I have a total, e.g., $45.00, and a group of cells with these numbers:

30.00
68.00
15.00

Is there a way I can find out which, if any, of these numbers total $45.00?

Thanks!

[NoS]

Monelle, it a few days since you asked this and there's been no responses, if you are still in need of a suggestion have a look at this similar question asked a few years ago on another forum with a solution that uses the Excel solver add-in.

http://superuser.com/questions/20492...-a-given-total

[pmyk]

In excel 2007, If ... End if can be used to check whether two totals equal the given value.
If there are more numbers, Do... Loop an be used.
I am a learner still.