I am basically writing my own customized Quicken. My problem is I have
a Spend Sheet with Date, Amount, Check Number & Category (Numeric). On
a summary sheet I have used Index and Match to pull a single Check
Number which matches a Category to show summarized Category info. For
example Category 1 (Gasoline), I'd like to see Total Amount (I have
that working) and ALL check numbers written against that Category.

My problem is I have multiple entries for each Category as my Spend
Sheet gets new entries added. With Index & Match I can pull the first
check number that matches the specified Category but I'd like to pull
ALL check numbers applied against that Category.

For sake of clarity, my Spend Sheet is formatted as follows:
Column A - Date
Column B - Amount
Column C - Check Number
Column D - Category

I feel like I'm missing something simple. Any help is appreciated.


--
Fly
------------------------------------------------------------------------
Fly's Profile: http://www.excelforum.com/member.php...o&userid=18101
View this thread: http://www.excelforum.com/showthread...hreadid=547438