One venture ..

Assuming your source table as posted is in sheet: X, data within A2:I8

Put in J2, normal ENTER:
=SUMPRODUCT((A$2:A$8=A2)*(F$2:F$8=F2)*(G$2:G$8=G2) *B$2:B$8)
Copy down to J8

Then in another sheet,
you have the symbols and dates sold listed in A1:B2, eg:
TSRA 3/21/2007
XRX 4/18/2007

Put in C1, array-enter (CSE):
=IF(COUNTA(A1:B1)<2,"",INDEX(X!J$2:J$8,MATCH(1,(X! A$2:A$8=A1)*(X!F$2:F$8=B1),0)))
Copy C1 down to return required results, viz 130 (TSRA) and 300 (XRX).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dallman Ross" <dman@localhost. wrote in message
...
Folks, I really could use some help here. I've spent hours
over the last few days flailing around without quite getting what
I need. I can do most of the work myself once I just get a
kick-start from somebody.

Maybe I should just ask one question at a time. Okay,
given a table like the one below, I need a formula -- I guess
an array formula -- to tell me the total shares sold per
day ("Date Sold") per specific selling price ("SPrice") for each symbol.

Thanks for any tips!

A B C D E F G H I
1 Symbol Shares Date Bot PPrice Cost Date Sold SPrice Proceeds
G/L
2 TSRA 100 3/1/2007 38.56 3,856.00 3/21/2007 41.05 4,104.93
248.93
3 TSRA 100 3/5/2007 37.66 3,766.00 3/21/2007 41.64 4,163.93
397.93
4 TSRA 30 3/2/2007 38.56 1,156.80 3/21/2007 41.05 1,231.48
74.68
5 TSRA 30 3/5/2007 37.66 1,129.80 4/5/2007 42.03 1,260.88
131.08
6 XRX 10 3/2/2007 16.86 168.60 4/18/2007 18.12 181.20
12.60
7 XRX 290 3/2/2007 16.86 4,889.40 4/20/2007 18.68 5,417.02
527.62
8 XRX 290 2/27/2007 17.36 5,034.40 4/18/2007 18.12 5,254.71
220.31

--
Dallman