Average/Sum Ignoring Blanks In-Range Help

Hello,

I am trying to figure out a formula that can take the average of the separate sums of a few ranges of cells. But the catch is that I need the function to completely ignore any range that has all blank cells.

Using the calendar template as a foot-traffic counter, I need the average of Mondays, Tuesdays, Wednesday, Thursday, & Fridays to be counted as they are input in each week. The catch is that I don't want the week to be counted in the average if ALL cells in that week are blank.

I've tried a billion formulas over the past few days, and my latest effort is this:
=AVERAGE((IF(COUNTA(B11:C19) > 0, SUM(B11:C19), "")),(IF(COUNTA(B22:C30) > 0, SUM(B22:C30), ""))).

I hope this isn't too confusing, and I appreciate any advice.

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.

Try:
=AVERAGE(SUM(B11:B19),SUM(B22:B30))

if incorrect, please supply a sample file, meeting the guidelines shown at the top of the screen.

Your file appears to be protected and is therefore useless to us. Please refer to the formula/file attached at mt last reponse.

The sheets are still protected so it is not possible to select cells with formulae to check and/or update/replace them.

No data in your file. No expected result sin your file... so reverting to my sample:

=IFERROR(1/(1/AVERAGE(SUM(B11:B19),SUM(B22:B30))),"")

or

=IFERROR(1/(1/AVERAGE(SUM(B11:B19),SUM(B22:B30))),"Null")