Average With Exclude Text,Blank Cell, Zero Number

muhammad susanto

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

Some videos you may like

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Watch MrExcel Video

Forum statistics

Threads
1,089,886
Messages
5,410,986
Members
403,336
Latest member
amreeves87

This Week's Hot Topics

Top