How to calculate total commision in excel

[yjohari]

How do you calculate the total commission of a particular person on a consecutive months ?

Any advice ?

Attached is the excel file for your reference.

[JBeaucaire]

=SUMPRODUCT((OFFSET($B$2:$M$2, MATCH("Jackie",$A$3:$A$15,0),,,) * ($B$18:$M$18)))

The "Jackie" reference could be replaced with a cell where you've entered the name you want the answer for, so if the name Jackie was in A23, then the formula in B23 could be:

=SUMPRODUCT((OFFSET($B$2:$M$2, MATCH(A23,$A$3:$A$15,0),,,) * ($B$18:$M$18)))



Now as you change the name in A23 the results will change.