Simple "if/then" statement has the best of me

[AmandaS]

Please help! Okay, so I'm inept at being able to attach a screen shot. Scenario is extremely simple though. I'll try to explain.

Column A = Customer Name
Column B = Dollar Amount
Column C = Sales Rep Name

I'm trying to place totals at the bottom of the data, separated by sales agent. So for Sales Rep "Bob", his "Total" box would include only his sales.

So, if C1=Bob, then add B1 to this box...

I'm confused.

Figured out the screen shot!
<a href="http://s53.photobucket.com/albums/g71/amandashank/?action=view&current=ExcelQuestion-1.jpg" target="_blank"><img src="http://i53.photobucket.com/albums/g71/amandashank/ExcelQuestion-1.jpg" border="0" alt="Photobucket"></a>

 

[VoG]

Try

=SUMIF(C1:C10,"Bob",B1:B10)

 

[AmandaS]

Brilliant, thank you. Okay one more question. Suppose the "Cheryl Total" cell was not there, and I wanted an "Other Total" cell that totaled everything OTHER than Joe or Bob?

 

[VoG]

There may be a cleverer formula but try

=SUM(B1:B10)-SUMIF(C1:C10,"Bob",B1:B10)-SUMIF(C1:C10,"Joe",B1:B10)

or simply subtract the Bob and Joe totals from SUM(B1:B10)