Excel 2002 Formula with multiple subtotals
Posted on 2003-03-30
Can anyone help me create a formula that calculates cells based on multiple subtotals?
(I am using Windows XP and Excel 2002 SP2)
Objective: Create a formula in Column G that subtotals Column D (Sales Reps Revenue)
when "like" departments in Column A.
For each row in Column G contains: The Sales Reps Department Subtotal
times Column E [# of Sales Calls] minus Column D [Revenue]
Excel Sheet: Column A - Department Number,
Column B - Dept Mgr Name,
Column C - Sales Rep Name,
Column D - Sales Rep's Revenue,
Column E - contains Number of Sales Calls
Column F - Blank
Column G - contains new formula
The sheet is sorted by Department number and Sales Rep name.
There are about 20 departments and a variable number of Sales Reps per department.