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

=SUMIF(A1:A100,"value")

--

HTH

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


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

For a possible solution see

http://tinyurl.com/4doog
--

Regards,

Peo Sjoblom



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

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

--
Regards,

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

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