Poker database

[cwik]

OK lets see if I can set this up straight.

I have a database I have made up for my poker play. I have it split up into devisions: Satellites, MTT's, and SNG's (it's ok if you don't know what these are). For each type I have a column for the entry $ amount and a column for the result $ amount. The I just have one column that calculates the total profit of the event in that row.

What I want to do is add two additional columns, one for the # of entrants and one for the place I finished. So it would look like this:


| Sat Entry amount | Satellite Result | MTT Entry amount | MTT Result | SNG Entry amount | SNG Result | Entrants | Place | Profit |

Now I want to do some functions such as:

=countif(Entrants,"1") , but only count rows that I have data entered in the Satellite Entry column.

and

also a formula that would calculate the percentage of time I finished in the top 10% of the field, but only count rows that have data entered in the MTT column.

[loumf]

I attached a sheet where you can see how to do Top 10% in MTT. It's broken down into columns.

[cwik]

hummm... that would work, but I'd rather have a way to do it that I didn't have to add more columns (on another sheet) to reference, would if I had to.

Anyone else have another way to do either of these?? I could handle doing this for the percentile. How about the first one?