bowling score record sheet help

I'm using Excel to keep track of my bowling scores. I can do the basic stuff with sums and averages and whatnot, but I need some help with some more complicated stuff.

I want to account for when I bowl more or less than 3 games a session. For example, if I only bowl one game and get a 180, I don't want it to think my average is 60.

I already started a basic spreadsheet if anybody wants to help me with what I'm trying to do. (Feel free to add more stuff like graphs and whatnot and make it look better if you feel like it)
Thanks in advance! :woop:

Download bowling.xls

Try this ...

Thank you!
That's exactly what I wanted, except you left the 'Series' column blank. The series should be the total of games 1, 2 and 3.

Also could you add an all time high + low game and series somewhere at the bottom?

Thanks again

OK. Try version 2.

Well ... I posted version 2 before I saw Noob's work. Now that I see his idea, I feel the need to highlight the all-time high & low scores. So ... here is version 3.

Just so you'll know what to expect ...

The all-time scores (high & low) and the chart are based on Names which will grow as the number of entries grows in Column B.

Columns B, C, and D have Conditional Formatting, so any score that equals the all-time high will be highlighted yellow and any score that equals the all-time low will be highlighted aqua blue. In other words, if you have more than one game with exactly the same score and it happens to be an all-time high or low, then you will see more than one game highlighted for that distinction.

Hope it meets your approval.