Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I would like to return the total amount of commission received per quarter
for different types of transactions. LISTINGS, SALES, REFERRALS, COMBOS Column 1 has the date of the transaction Column 2 has the TYPE Column 3 has the commission amount What I like to do is return the total commission per quarter, per type. Hence I am looking for a formula that would evaluate A1:A100 for a date between 1/1 and 3/31 *AND* B1:B100 for TYPES equal to LISTINGS, and then total all corresponding dollar amounts in Column C for the rows where column A & B meet the requirements 1/1 LIST 10,000 3/3 SALE 25,000 3/29 LIST 4,000 4/13 LIST 13,000 5/22 LIST 7,000 7/8 LIST 4,000 So in the example above, 1st QTR LIST TOTAL should return 14,000. I really don't know how to accomplish this and would appreciate any guidance. Thanks! -cypher |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sumproduct on filtered cells | Excel Worksheet Functions | |||
Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
SUMIF with only one criteria cell within range | Excel Discussion (Misc queries) | |||
SUMPRODUCT using offset from ROW if X marks the spot | Excel Worksheet Functions | |||
Conditional Format With SUMIF | Excel Worksheet Functions |