AVERAGEIFS & SUMIFS return ERROR even as data is non-zero

Though this seems a common question, I haven't found one that quite meets my situation.

Even when data in range are neither zero or non-blank, my AVERAGEIFS and SUMIFS return #DIV/0! and " - ", respectively. This doesn't make sense.

Errors are shown in J53:K55; the results that should be are in J185:K187, where column J refers to AVERAGEIFS and K to SUMIFS. Corresponding calc ranges are to the right.

Please Login or Register  to view this content.

Screen Shot 2019-09-10 at 3.42.04 AM.png

First, the data is there, how can I get Excel to output the correct responses?

Secondly, is there formula that can evaluate the ranges even when "zero" and "blank" exist?

Thank you!

Ah ha, ">=" works; "=>" does not. Made all the difference, so much work saved!

Thank you Glenn! Also, I'm not sure when "" is appropriate to use. I was thinking that it would help the formula skip zeros. It seems it just makes things more complicated and that averageifs skips them anyway.

Yes. Apologies, I'd click the "reputation" button ten times if I could. Thanks again, Glenn!

--- whoops, it seems I already did both. Thanks Glenn!