Dear Yvonne, 2 solusi diberikan :
=SUMPRODUCT(($A$5:$A$35>=H3)*($A$5:$A$35<I3)) =FREQUENCY($A$5:$A$35;I3:I8) ยป Array formula Blessings, Fran'z On 6/10/11, Yvonne <[email protected]> wrote: > Dear TTM, > > mohon bantuanny untuk masalah terlampir. > saya mengalami masaalah dlm kriteria. > > tq
fran'z_Masa Kerja 20110610.xls
Description: MS-Excel spreadsheet
