I'm compiling some stats and I want to figure out how to ignore blank cells in a range within an array. I'm a rookie to all this, so speak "idiot" to me.

Specifically, I'm trying to factor how consistent players are by calculating how many weeks were spent in various ranges based on their overall average. The issue I'm having is that each player didn't play each week, which is messing up the results.

This is where I'm at right now:

=SUM((G38:U38=(AC38-50))*(G38:U38<=(AC38-10)))

This shows a 16 week season (G38:U38 represents each week). AC38 represents the player's season average. The issue is that this player only played in 8 of the team's 16 weeks. The average is correct, but the array is counting the 8 weeks that he didn't play as "0."

(This particular array is displaying the number of weeks the player was 10-50 points under his season average.)

Can anybody out there help a stat-geek learn a new trick?