How do I add a range of numbers to sum a specific total?

[SJoshi]

How do I add numbers from a range of numbers (selecting only certain in that
range) to come up with a specific total?

 

[Bob Phillips]

=SUMIF(A1:A100,"value")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

For a possible solution see

http://tinyurl.com/4doog

 

[Tushar Mehta]

You may also want to check
Find a set of amounts that match a target value
http://www.tushar-mehta.com/excel/tips/template-set-match.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions