=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?