Hi hidayat
Alternatif formulanya pake COUNTIFS (multiple criteria):
=COUNTIFS($B$5:$B$20,DATEVALUE("22-Jan-9"),$C$5:$C$20,"a")
Atau tanggalnya dibuat relatif
=COUNTIFS($B$5:$B$20,DATEVALUE(TEXT(K17,"dd-mmm-yy")),$C$5:$C$20,"a")
From: [email protected] [mailto:[email protected]] On
Behalf Of raya hidayat
Sent: Friday, January 30, 2009 7:58 AM
To: [email protected]
Subject: ]] XL-mania [[ count cell bermasalah
Dear XL-Mania.
aku menemui masalah dengan countif.
mohon bantuannya
--
Terima kasih
Raya
