MENGHITUNG JUMLAH TOTAL DENGAN MENGABAIKAN NUM! DAN VALUE!
84 views
Skip to first unread message
Sugianto SSi
Oct 20, 2012, 1:54:24 PM10/20/12
to belaj...@googlegroups.com
| ANG/BLN | OS POKOK | ANGS POKOK | MARGIN |
| 49,953,677.29 | #NUM! | 49,255,886.61 | 697,790.68 |
| 23,485,684.10 | #NUM! | 23,157,619.02 | 328,065.08 |
| 10,065,293.19 | 9,924,693.36 | 9,786,058.63 | 279,234.55 |
| 215,757,636.52 | 833,309,914.33 | 201,103,448.23 | 14,654,188.28 |
| 5,716,092.43 | 22,076,977.52 | 5,327,858.46 | 388,233.97 |
| 5,094,793.88 | 19,677,367.26 | 4,748,758.14 | 346,035.74 |
| 1,105,939.62 | 5,302,239.77 | 1,016,426.57 | 89,513.05 |
| 248,525.76 | 1,191,514.56 | 228,411.53 | 20,114.23 |
| 288,550.42 | #VALUE! | #VALUE! | #VALUE! mohon bantuannya bagaimana cara menghitung total dengan mengabaikan num! dan value! |
Ferioso a.k.a. Feris Thia
Oct 20, 2012, 9:49:58 PM10/20/12
to belaj...@googlegroups.com
Pak Sugianto,
Coba lihat solusinya pada file Excel terlampir. Kuncinya di fungsi SUM dan IF, tapi dengan pendekatan array formula.
Jika masih baru dengan array formula, url berikut mungkin bisa membantu Pak :
Semoga membantu ya Pak..
Regards,
Feris
--
-- You received this message because you are subscribed to the Google Groups Belajar Excel group. To post to this group, send email to belaj...@googlegroups.com. To unsubscribe from this group, send email to belajar-xls...@googlegroups.com. For more options, visit this group at https://groups.google.com/d/forum/belajar-xls?hl=en
Sugianto SSi
Oct 21, 2012, 5:19:08 AM10/21/12
to belaj...@googlegroups.com
terima kasih banyak pak feris
Ferioso a.k.a. Feris Thia
Oct 21, 2012, 5:52:28 AM10/21/12
to belaj...@googlegroups.com
Sama-sama Pak Sugianto,
Feris
Semoga membantu ya...
Regards,
Feris
Reply all
Reply to author
Forward
0 new messages