The scenario:
I have a spreadsheet to track my stocks. Each stock has its own worksheet
with the stock symbol as the worksheet name (ie IBM). I also have a
worksheet that summarizes all the individual sheets. On the individual stock
sheets there is a column (B) for the transaction type (buy sell dividend
split etc) and a column (C) for the amount.
Now for my problem:
I want to be able to list on the summary sheet the last amount received for
each transaction type for each stock. I have tried various LOOKUP functions
and the OFFSET function, but I always just come up with the last value in the
column, not the last value for a particular transaction type.

I am new to the forum so any and all help would be appreciated.