Baseball Results: H/G when Games<30 & AB/G when Games<10

The previous formulas (from this thread: https://www.excelforum.com/excel-for...mic-stats.html) work perfectly for calculating only the last "n" number of games as specified. Now, I'm looking to calculate it when those minimums are not met. I know it's right there in front of me, but for some reason I can't see it. I'm looking for a formula that will do the following:

• Column I: Calculate Avg Hits/Game ONLY when Games Played < 30 (and output "n >= minG" when Games Played >= 30)
• Column J: Calculate Avg ABs/Game ONLY when Games Played < 10 (and output "n >= minG" when Games Played >= 10)

I have attached a sample of my data and the output I'm looking for highlighted in yellow. Thank you again!!!

Best regards,
Eric

Originally Posted by AliGW

Actually, it was more simple than I had anticipated!

=IF(COUNTIF('B - Log'!E:E,'B - Stats'!C2)>=30,"n < minG",AVERAGEIFS('B - Log'!P:P,'B - Log'!E:E,'B - Stats'!C2,'B - Log'!B:B,">"&MAXIFS('B - Log'!B:B,'B - Log'!E:E,'B - Stats'!C2)-30))

and

=IF(COUNTIF('B - Log'!E:E,'B - Stats'!C2)>=10,"n < minG",AVERAGEIFS('B - Log'!N:N,'B - Log'!E:E,'B - Stats'!C2,'B - Log'!B:B,">"&MAXIFS('B - Log'!B:B,'B - Log'!E:E,'B - Stats'!C2)-10))

seem to do what you want.

You're kidding me, right? That's literally the exact same formula with the first criteria adjusted for my request. I knew it was right there in front of me.

Originally Posted by AliGW

Yup! Not enough coffee yet this morning foe me ...

Begrudgingly, SOLVED. Apparently it's too late in the day for me. Thank you.