Hi everybody,
I am coming across some difficulties in regards creating a formula. For demonstation purposes please see the example attached. The two formulas are aimed to:
1. In the cell filled with yellow, calculate Mike's total commission (i.e. 400 as 100+200+100)
2. In the cell filled with blue, calculate Mike's total units sold (i.e. 3)
I appreciate any help guys. Thanks.
edit: please ignore the attachement on the left.
Bookmarks