Wondering if there is a formula to do the following:
Add the Sales from column G up to the value in column B for a specific Person from column A. For example, I'd like to calculate Matt's sales by summing G3, and G6 up to the value from B2, and multiply their sales by their profit.
Handwork would be:
45*.75 + 55 * .7
The 65 comes from Matt's value of 100 - Matt's 1/22 sale for 45 - Matt's 1/21 sale for 74 (but that goes over 100 so only counting 55 of the 74)
Bookmarks