Average With Exclude Text,Blank Cell, Zero Number

muhammad susanto

Well-known Member
Joined
Jan 8, 2013
Messages
1,509
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,082,548
Messages
5,366,227
Members
400,880
Latest member
dwb

Some videos you may like

This Week's Hot Topics

Top