Analyze Range of Cells
 

Can excel look at a range of values (number) and tell me if any of the cells
add up to a specific number?

Analyze Range of Cells
 

Yes, using Solver.

"Rhonda" wrote in message
...
Can excel look at a range of values (number) and tell me if any of the
cells
add up to a specific number?

Analyze Range of Cells
 

Yes... This topic is very well covered in:

http://www.tushar-mehta.com/excel/te...ues/index.html
--
Gary''s Student - gsnu200715

Analyze Range of Cells
 

I don't want it to change my existing values, I want it to see if any
combination of my values will = a specified number.

"Bob Umlas" wrote:

Yes, using Solver.

"Rhonda" wrote in message
...
Can excel look at a range of values (number) and tell me if any of the
cells
add up to a specific number?