Average With Exclude Text,Blank Cell, Zero Number

[muhammad susanto]

hi all..

how to make average formula exclude 3 criteria text, blank cell, zero (0)
=IF(COUNT(H8:T8);AVERAGE(H8:T8);"")

but still not fully working

thanks in advance..

.sst

 

[steve the fish]

Try

=AVERAGEIFS(H8:T8,H8:T8,">0")