Adding a 2nd IF to CSE (Array) formulas

[RegW]

MrExcel has a great example of CSE formulas posted on
http://www.mrexcel.com/articles/CSE-array-formulas-excel.php

My question: how can I add a condition to ignore zeros or empty cells?

I tried:

=AVERAGE(IF($C$2:$C$10<>0,IF($a$2:$a$10=A13,$C$2:$C$10)))

But it doesn't work.

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=AVERAGE(
    IF($A$2:$A$10=A13,
    IF(ISNUMBER($C$2:$C$10),
    IF($C$2:$C$10>0,
     $C$2:$C$10))))