Dear Ahmad,
Kalau aku lihat sekilas.. untuk yang A, secara rumus sudah oke...
cuma satu... yang buat hasilnya jadi nol.....
nama A di ke dua sheet tidak sama....
(ada spasi di sheet data , sedangkan di sheet view itu tidak ada spasi)
note : spasi = spacebar
mudah-mudahan sesuai dengan yang diinginkan.
2009/12/21 Ahmad <itd@wonwaymfg.
> Assalamualaikum wrt..
>
> Apa khbr sahabat2 excel sekalian...
>
> saya ingin meminta bantuan bagi menyelesaikan masalah sy.
>
> Bagaimana saya nak mengira jumlah hours bagi seseorg mengikut jenis time off
> di Sheet DATA.
> Saya dah cuba menggunakan sumproduct, tapi x dapat kerana sy x tau formula
> untuk mengira time.
> Ataupun sahabat2 ada cara yg lebih baik.
> Harap Sahabat2 sekalian dapat membantu saya...
>
> Terima Kasih
> Ahmad
> /-----------
>
> Confidential and/ or privileged information may be contained in this
> e-mail and any attachments transmitted with it ('Message'). If you are
> not the addressee indicated in this Message (or responsible for
> delivery of this Message to such person),you are hereby notified that
> any dissemination, distribution, printing or copying of this Message or
> any part thereof is prohibited. Please delete this Message if received
> in error and advise the sender by return e-mail. Opinions, conclusions
> and other information in this Message that do not relate to the
> official business of this company shall be understood as neither given
> nor endorsed by this company.
>
> This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd)
> *Scanner Engine powered by Norman Virus Control
>
> \-----------
>
>
--
Terima kasih
Raya
| Ini work-load atau work-flood ya? ada lowongan jadi direktur? |
| http://www.facebook.com/group.php?gid=37671048001&ref=mf |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message, melecehkan, tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan winzip jika perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/ |
+-------------------------------------------------------------------+
| Berikan testimoni di : http://www.friendster.com/xlmania atau... |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html |
+-------------------------------------------------------------------+
| Message lama ada di : |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id] |
| http://www.mail-archive.com/xl-mania@yahoogroups.com |
+-------------------------------------------------------------------+
Nenhum comentário:
Postar um comentário