Mar 30 2021 02:39 AM
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!
Mar 30 2021 03:24 AM
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.