View Single Post
  #1   Report Post  
|| cypher ||
 
Posts: n/a
Default 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