# 2 questions

#### l KAUTION l

##### Board Regular
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?

### Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
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

Book1
ABCD
1ABAvg15
26.221.400
3123.252
422.333
50.000
650.400
733.350
814.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.

Replies
20
Views
563
Replies
9
Views
170
Replies
0
Views
154
Replies
4
Views
266
Replies
10
Views
381

1,206,971
Messages
6,075,922
Members
446,170
Latest member
zzzz02

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back