Average With Exclude Text,Blank Cell, Zero Number

muhammad susanto

Well-known Member
Joined
Jan 8, 2013
Messages
1,499
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
 

Forum statistics

Threads
1,077,633
Messages
5,335,371
Members
399,014
Latest member
hamzalaarif

Some videos you may like

This Week's Hot Topics

Top