Maaf Salah copy formula pada bagian bawah (warna merah)
Salam,HK ----- Forwarded message ----- From: hendrik karnadi [email protected] [belajar-excel] <[email protected]>To: BeExcel <[email protected]>Sent: Wednesday, 29 August 2018, 11:34:07 PM GMT+7Subject: Fw: Re: [belajar-excel] Rumus Jumlah berdasarkan waktu [1 Attachment] Pinjam formula Mr. Kid + Kolom Bantu...file terlampir. Salam,HK ----- Forwarded message ----- From: 'Mr. Kid' [email protected] [belajar-excel] <[email protected]>To: BeExcel <[email protected]>Sent: Wednesday, 29 August 2018, 8:47:40 PM GMT+7Subject: Re: [belajar-excel] Rumus Jumlah berdasarkan waktu Begini :=$F4*(COLUMN(A1)=MATCH($G$1-$G4,{0,31,61,92,121,151,181,210,241,271,301,331,361})) Regards,Kid On Wed, Aug 29, 2018 at 6:50 PM halak hita [email protected] [belajar-excel] <[email protected]> wrote: Dear para MasterMohon dibantu dalam lampiran berikut.apa rumus tepat dan yang mudah dipahami agar data (yang diberi warna kdapat menyesuaikan otomatis seiring berjalannya waktu salamHH
