Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct Help PLEASE
ColumnA Column B ColumnC ColumnD
$2,958.73 Kelly RSP 5-Feb-07 $91,000.00 Sherri Non-Reg 12-Feb-07 $15,648.47 Kelly RRIF 21-Mar-07 These are my columns. I want to make a running total for each salesperson PER QUARTER. So if their name appears in Column B AND Jan, Feb or Mar appears in Column D, I want it to add their sales numbers from Column A to this quarterly total: Ex) Kelly appeared in Col B AND Feb appeared in Column D so it added $2958.73 to her total quarterly sales: Kelly 1st Quarter Sales $18607.2 (total sales for Jan,Feb,Mar) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct Help PLEASE
Hi,
Maybe =SUMPRODUCT((B2:B100=E1)*(D2:D100=F1)*(D2:D100<=G 1)*A2:A100) Where E1 = Name to find F1 = Quarter start date G1 = Quarter end date Mike "cdw" wrote: ColumnA Column B ColumnC ColumnD $2,958.73 Kelly RSP 5-Feb-07 $91,000.00 Sherri Non-Reg 12-Feb-07 $15,648.47 Kelly RRIF 21-Mar-07 These are my columns. I want to make a running total for each salesperson PER QUARTER. So if their name appears in Column B AND Jan, Feb or Mar appears in Column D, I want it to add their sales numbers from Column A to this quarterly total: Ex) Kelly appeared in Col B AND Feb appeared in Column D so it added $2958.73 to her total quarterly sales: Kelly 1st Quarter Sales $18607.2 (total sales for Jan,Feb,Mar) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Please help w/Sumproduct! | Excel Worksheet Functions | |||
Sumproduct | Excel Discussion (Misc queries) | |||
SUMPRODUCT - Help | Excel Worksheet Functions | |||
Sumproduct Help | Excel Worksheet Functions |