Please assist with a SUM function in Excel 2003. I need to add numbers from
4 of 8 columns (sales dollar amounts - the other columns are counts) IF the
text in the row = a certain value (sales agent name). There are over 200
rows (by sales agent) in the worksheet. Then I need to total all of the
sales agents dollars in the report.

SAMPLE: columns seperated by commas to illustrate
Brown, $300, 5,$200, 1
Smith, $250, 3, $100, 1
Brown, $200, 4, $250, 2
Jones, $550, 6, $500, 4
Jones, $600, 4, $450, 5

Formula need to produce:
Brown, $950
Jones, $2100
Smith, $350