Can anyone tell me why the following SUMIF formula doesn't work? I get a "the formula you typed contains an error" message when I ctrl+shift+enter:
=SUMIF(N(OFFSET(Stats!$B$4,D64:D81,))/MMULT(N(OFFSET(Stats!$B$4,D64:S81,)),TRANSPOSE(COLUMN(D64:S81)^0)),">0")/18

I find this odd because the same formula works with SUM:
=SUM(N(OFFSET(Stats!$B$4,D64:D81,))/MMULT(N(OFFSET(Stats!$B$4,D64:S81,)),TRANSPOSE(COLUMN(D64:S81)^0)))/18

Essentially, I am attempting to avoid DIV/0! errors using this method. I have seen other methods but it makes the code harder to follow and I'm trying to keep it as clean as possible. Can anyone help! I could use some wizardry!