Excel 2003 or 2007 Formula Help

**patientsafety** · 04-10-2010, 04:36 PM

I am looking for help with If and then functions.

I am making a spreadsheet to track customers expenses by the division they are in. I have a list of customers in Column A, each assigned to a particular division in Column B (may have many duplicates), and how much each spent in Column C. I want to keep a running total of the amount each division spends. So off to the side, starting in say E4, I would have a division name and next to it in E5, a sum of all the money spent from the customers in Column A that are assigned to that division.

If a cell A2 has a particular name, assigned to a division in B2 and then a dollar amount in c2, What is the formula to put in E5?

Hope this makes sense.

Thanks in advance for any help.

**contaminated** · 04-10-2010, 04:38 PM

Forum Rules And Guidance
1. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

**teylyn** · 04-10-2010, 09:08 PM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.