For greater than 725 use:

=SUMIF(C1:C5,"725",B1:B5)

for greater than 600 and less then or equal to 725 try:

=SUMIF(C1:C5,"<=725",B1:B5)-SUMIF(C1:C5,"<600",B1:B5)


--
HTH

Sandy

with @tiscali.co.uk


"pdgaustintexas"
<pdgaustintexas.21yg0m_1137796806.7659@excelforu m-nospam.com wrote in
message news:pdgaustintexas.21yg0m_1137796806.7659@excelfo rum-nospam.com...

I need a formula that will add amounts in Column B if it falls within
certain range in Column C.

If Column C is greater than 725, then add amount in Column B (answer
will be $47).
If Column C is greater than 600, but less than 725, then add amount in
Column B (answer will be $45), and so.
Ex:
A B C
Joe $10 655
Jim $20 745
Tom $25 550
Sam $27 738
Amy $35 627


--
pdgaustintexas
------------------------------------------------------------------------
pdgaustintexas's Profile:
http://www.excelforum.com/member.php...o&userid=30600
View this thread: http://www.excelforum.com/showthread...hreadid=503537