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.

You guys rock.

Thanks a ton.

I wanted to add in High Series and Low Series and I was wondering where you defined (Games) so I could make a MAX(Series) and also how you highlighted things.

Sorry, I know I could be digging through tutorials, but you guys are so friendly...

It would take a lot longer to find it in a tutorial.

Look at Insert >> Name >> Define
You will find that the formula for "Games" is

Please Login or Register  to view this content.

This means it starts from cell B2, and "offsets" no rows and no columns, it is is "x" columns tall, where x=the number of non-blank cells in column B (minus 1 for the header), and 3 columns wide.

What you want for maximum and min series could be simpler since you only need to consider a single column for this. But, I think you only want to consider those series where you played 3 games, right?

Let me work on that.

Thanks so much.

You're super

I have been searching for a spreadsheet to asist my mom with her duties as secretary of her bowling league. thanks, this is a good start.