Add only the cells after a particular number in the previous cell in the same column

D

DrSues02

A tie is symbolized using a T. Basically, I just dont want to include
it in the games at all. Is this possible? Using the same formula for
win %, but to ignore the cells with a T in it?

Some more help:

I am figuring out over/unders for football games. I have a list of all
possible lines that could be posted...40, 40.5, 50, 50.5 etc in one
column. Then I have a list of all of my games and that actual line
that was posted. I figured out how to calculate how many games were
played at the particular line, and then to figure out the number of
times the game went over vs the number of times the game went under.
The formula I used was:

=SUMPRODUCT(--(I1:I1000="O")*(J1:J1000=L2))

With "O" being the designator for a game going over. Basically, it
looks at all my games, matches the "O", and then counts the number of
times it uses the particular line in "L2".

Now, my question. My results are formulated like this:

# # of times over under over % under %
40 0 0 0 #DIV/0! #DIV/0!
40.5 2 0 2 0.00% 100.00%
41 1 1 0 100.00% 0.00%
41.5 1 0 1 0.00% 100.00%
42 0 0 0 #DIV/0! #DIV/0!
42.5 3 1 2 33.33% 66.67%
43 0 0 0 #DIV/0! #DIV/0!
43.5 0 0 0 #DIV/0! #DIV/0!
44 1 1 0 100.00% 0.00%
44.5 1 0 1 0.00% 100.00%
45 2 1 1 50.00% 50.00%


So I take the number of times Over, divide it by the total # of times,
to get my winning percentage.

Now, I would like to display these results on another worksheet. I
have another worksheet broken down into ranges such as 40-45 and 45-50.
I want to take the numbers above. Add up the total amount of times
that these lines occured in the 40-45 range, count how many times the
Over occurred in this range, and then output the %. Is this possible?

Thank you for everything. It has been a great help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top