Formula problems

[Jerminator]

OK, just a thanks up front if anyone can help me. I have a monthly report to generate. I need to calculate a colum in this report, a simple sum of entire column. My problem is I need to subtract from that total any duplicates based on another column. Example: Column A: Name Column B: Dollar Amount. =SUM(B:B) But in the Name column I dont want to sum the dollar amount of repeated names. Thanks again

 

[Jerminator]

Thanks, this was a great help. I have it working