find specifc total among group of cells with numbers

Monelle

New member
Joined
Nov 18, 2013
Messages
1
Reaction score
0
Points
0
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!
 

pmyk

New member
Joined
Oct 15, 2013
Messages
14
Reaction score
0
Points
0
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.
 
Top