2 questions

[l KAUTION l]

I am making a spreadsheet for baseball.

Question #1:

I am looking for the Batting Average Leader.

I have a vlookup to find the max under the batting average category.

It returns the player with the best average just fine, however that player has only had like 2 at bats.

Is there a formula where I can get the max batting average from the players with more than say 15 at bats?

Question #2:

I have individual game sheets in my workbook.

Is there a way to update the totals sheet automatically when I add a new game sheet to my workbook?

So far I have about 15 game sheets.

In my leaders sheet I populate say cell A1 with game1!A1+game2!A1+etc...

Then I'll add a new sheet, say game34 and populate the sheet with the stats from that game.

Is there an easy way to add the game34 sheet to the totals sheet?

 

[lenze]

You can probably use SUMPRODUCT for question number 1, but DMAX is also a good way go as you can refer to the criteria as a variable, negating the need to update your formula as the required number of At Bats increases.

For number 2, insert a new sheet at the end of the workbook and name it Final. Now on your total sheet, the formula becomes SUM(Game1!A1:Final!A1). Insert each new game sheet between Game1 and Final.

HTH

lenze

 

[just_jon]

Book1
	A	B	C	D
1	AB	Avg	15
2	6	.221	.400
3	123	.252
4	22	.333
5	0	.000
6	50	.400
7	33	.350
8	14	.399
9
Sheet3

The above is an array formula, which requires entry via Control+Shift+Enter [CSE], not just Enter. Any direct edit of the formula will require re-entry via CSE. You can tell if the formula has been entered correctly, as it will have braces - { } - around it afterward.