Cjluke
05-22-2007, 09:02 AM
I don't think this is that hard in terms of some of the stuff I see on here, but its driving me crazy. The attached spreadsheet has a list in it for investment trades. I need to be able to to find the particular types of trades for each trader ID. So, if I needed to find information for trader 6, I would need a formula that would find all entries for "6" in the Trader ID column, and then I need the formula to find all the "P" entries in the Broker ID column that correspond with trader 6, and then all of the "10" entries in the Trade ID column that correspond with broker "P", and then the sum of all of the "10" entries.
What this corresponds to is the sum of all VRDN trades done through Broker P by Trader 6.
I will need to do this in many flexible combinations. Like if I wanted to find the number of "7" trades in the Trade ID Column that correspond with Broker N and Trader 2.
I tried using the following:
IF(B2:B40000=6,COUNTIF(C2:C40000,"F"),0)
However, this just ends up returning the total number of trades down with broker F. Any help would be appreciated. Thanks!
What this corresponds to is the sum of all VRDN trades done through Broker P by Trader 6.
I will need to do this in many flexible combinations. Like if I wanted to find the number of "7" trades in the Trade ID Column that correspond with Broker N and Trader 2.
I tried using the following:
IF(B2:B40000=6,COUNTIF(C2:C40000,"F"),0)
However, this just ends up returning the total number of trades down with broker F. Any help would be appreciated. Thanks!