-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating
Data Smart
By :
In the concession transaction workbook, there is a tab called Fee Schedule. As it turns out, Coach O'Shaughnessy would let you run the snack stand only if you kicked some of the profit back to him (perhaps to subsidize his tube sock-buying habit). The Fee Schedule tab shows the percent cut he takes on each item sold.
So how much money do you owe him for last night's game? To answer that question, you need to multiply the total revenue of each item from the PivotTable by the cut for the coach and sum them all up.
There's a great formula for this operation that will do all the multiplication and summation in a single step. Rather creatively named, it's called SUMPRODUCT. In cell E1 on the Revenue By Item sheet, add a label called Total Cut for Coach. In C2, determine the SUMPRODUCT of the revenue and the fees by adding this formula:
=SUMPRODUCT(B2:B15,'Fee Schedule'!B2:O2)
Uh oh. There's an error; the cell just reads #Value. What&apos...
Change the font size
Change margin width
Change background colour