Re: ]] XL-mania [[ cell kuningku ini harusnya pakai rumus apa ya?

 

Dear Rano,

rumus dari pemula, jadi rada panjang.. di cell c6 rumusnya.. (tinggal tarik ke kanan & bawah)

=SUMPRODUCT(LARGE(((C$3=$B$21:$B$48)+(C$4=$B$21:$B$48)+(C$5=$B$21:$B$48))*($B6=$A$21:$A$48)*($C$21:$C$48),1))

tapi musti disempurnain lagi karen tampilan untuk cell yang gak ada itu 0 bukannya #NA seperti yang diminta..

blessings,
tomz

2010/3/11 rano <sales1@hitachi-cmi.co.id>

 

Dear XL-Mania

minta tolong formula-nya untuk mengisi cell kuning dunk ...!!
pleaseeeee....

Thanks yah ..
rano

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 101

Visit Your Group

+-:: XL-mania ::::::::::::::::::::----------------------------------+
| tolong carikan momods kerjaan jadi direktur :D :D :D              | 
| 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              |
+-------------------------------------------------------------------+

MARKETPLACE

Check out Yahoo! Movies to get a recap of this year's Oscar winners, red carpet looks & nominated film trailers.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___