Coba formula : =SUMIF(A4:G4,">0")/COUNTIF(A4:G4,">0")
Regards. Kid. 2011/10/14 Suhendra St <[email protected]> > ** > > > Dear all > para excel-ers > > mohon bantuanya bagai mana cara menghitung rata2 bila ranges yg di tuju > berisi : blank (kosong) ; tanda minus/simbol/huruf ; yg penting angaka > nol (0) > > terima kasih > > >
