LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumproduct on filtered cells Ndel40 Excel Worksheet Functions 19 January 20th 05 10:17 PM
Sumproduct ... Empty Cells vs Spaces? Ken Excel Discussion (Misc queries) 9 December 17th 04 08:03 PM
SUMIF with only one criteria cell within range Stan Excel Discussion (Misc queries) 5 December 16th 04 10:12 PM
SUMPRODUCT using offset from ROW if X marks the spot The Shaffer s Excel Worksheet Functions 3 November 2nd 04 06:14 AM
Conditional Format With SUMIF Minitman Excel Worksheet Functions 3 November 1st 04 02:58 PM


All times are GMT +1. The time now is 05:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"