Excel average/averageif question

[pretzman21]

Hi,

I've setup an excel spreadsheet to keep track of my bowling league. I'm tracking 3 games for each bowler across various worksheets and calculating handicap and average. The average and handicap are tracked in one cell each for each bowler, not across each different week. On occasion, a bowler may not show up and I would add an absent score.

Here is the scenarios that I am stuck on, I want to include the absent scores for tracking purposes, but do not want to include that week's scores in the average. My question is, how do I modify my average formula to still track averages without having to modify that bowlers cell formulation for each new absence? I've got a column of cells where I'm already inputting "R" or "A" for regular and absent. I was thinking that an averageif statement might be the way to go, but cant think of how I'd use it best.

Here is a link to what the spreadsheet looks like for one team. https://prnt.sc/klthlc

Here is the current formula that I have: =IF(Bowlers!B1>=3,TRUNC(AVERAGE(D7:F41)),"") .

Any help would be appreciated. Thank you.

 

[FDibbins]

Take a look at using averageif() for this