Summing commission totals by month.

[allegue]

Need help creating an Excel formula for adding commission income depending on who the salesperson is and the month in which the commission was received.

A B C D
1 MONTH COMMISSION MONTH TOTALS
2 Jan $1,000 January
3 Feb $2,000 February
4 Jan $100 March
5 Feb $100 April
6 Mar $2,000 May
7 Jan $400 June


In the cells above is a sample of what the sheet looks like. I like to figure out this:
• If cell A2 says “Jan” then take the dollars amount adjacent at B2 and put it in cell C2 (total Jan Income)
• If cell A4 says “Jan” again, then take the dollar amount adjacent at B4 and add it to the amount that is already at C2 (total income for Jan)

I’ve tried using “If then” formulas, but just can’t see to get it right.

Can anyone help?

Albert Allegue

[Richard Buttrey]

Hi, and welcome to the forum. Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem.

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.

Since this is your first post I'll change it for you on this occasion but please note for the future.

Your Q. also mentioned adding amounts depending on the sales person but your example doesn't have a column for sales people. Would you like to update your example. And rather than replicate the values in a post, why not upload your actual workbook -or at least a reduced copy of it with any sensitive data anonymised. That makes it so much easier for those who try to help you.

[FDibbins]

post self-deleted

[RobertMika]

In C2 drag down
=SUMIF($A$2:A2,A2,$B$2:B2)

[mehmetcik]

Sorry Albert

Your explanation makes no sense.

I'll explain as a private message

Good Luck.

[mehmetcik]

I think your title has been change so I'll post my table for you to look at.

You need to explain where your salesmen come into the picture.

[FDibbins]

mehmetcik, no change was made to the title, and it seems that to at least some members, theexplanation makes some sense?

[Richard Buttrey]

Sorry Albert

Your explanation makes no sense.

I'll explain as a private message

Good Luck.

@mehmetcik & allegue

Please note that neither party should be using Private Messages when discussing posts. The forum is for the benefit of all and there may be others either now or down the line who want to see these responses.

[FDibbins]

Thanks Richard, I missed the PM part

[mehmetcik]

Ok

The attached sheet demonstrates two solutions.

The bulk is a standard solution.

Line 11 shows how the sumif function can be used to sum all the required commissions in only one line.

Modify it to meet your specific needs.

[RobertMika]

Is it not the .xlsm format little misleading?
I woudl expect macro solution or a VBA code somewhere.