SUMIF or SUMPRODUCT or something else?
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
|