Monthly Commission Calculations

%3CLINGO-SUB%20id%3D%22lingo-sub-2244115%22%20slang%3D%22en-US%22%3EMonthly%20Commission%20Calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2244115%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20work%20out%20how%20to%20total%20monthly%20commissions%20based%20on%20having%20to%20add%20two%20amounts%20together%20depending%20on%20the%20month%20they%20were%20earned.%20Here's%20what%20I've%20done%20so%20far.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20add%20the%20commissions%20on%20the%20table%20underneath%2C%20but%20cannot%20work%20out%20how%20to%20add%20various%20cells%20depending%20on%20if%20their%20corresponding%20month%20is%20'January'%20for%20e.g.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20note%20that%20Commission%201%20could%20be%20earned%20in%20one%20month%20and%20commission%202%20could%20be%20earned%20in%20another.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20anyone%20able%20to%20help%20me%20with%20this%3F%20much%20appreciated!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2244115%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2244203%22%20slang%3D%22en-US%22%3ERe%3A%20Monthly%20Commission%20Calculations%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2244203%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1009511%22%20target%3D%22_blank%22%3E%40TR7676%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20B34%3A%3C%2FP%3E%0A%3CP%3E%3DSUMPRODUCT(--(LEFT(%24C%247%3A%24C%2431%2C3)%3DA34)%2C%24F%247%3A%24F%2431)%3C%2FP%3E%0A%3CP%3EIn%20C34%3A%3C%2FP%3E%0A%3CP%3E%3DSUMPRODUCT(--(LEFT(%24H%247%3A%24H%2431%2C3)%3DA34)%2C%24I%247%3A%24I%2431)%3C%2FP%3E%0A%3CP%3EFill%20down%20from%20B34%3AC34%20to%20B45%3AC45.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Good Morning All, 

 

I'm trying to work out how to total monthly commissions based on having to add two amounts together depending on the month they were earned. Here's what I've done so far.

 

I need to add the commissions on the table underneath, but cannot work out how to add various cells depending on if their corresponding month is 'January' for e.g. 

 

Please note that Commission 1 could be earned in one month and commission 2 could be earned in another. 

 

Is anyone able to help me with this? much appreciated! 

2 Replies

@TR7676 

In B34:

=SUMPRODUCT(--(LEFT($C$7:$C$31,3)=A34),$F$7:$F$31)

In C34:

=SUMPRODUCT(--(LEFT($H$7:$H$31,3)=A34),$I$7:$I$31)

Fill down from B34:C34 to B45:C45.

You're a bloody Excel genius. Thank you