RE: ]] XL-mania [[ Grand Total Formula

Sun, 23 Apr 2006 23:02:01 -0700

Ini pake formula SUMIF ajah.
=SUMIF($B:$B,"=Subtotal",$C:$C)
 
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED]On Behalf Of FaDLi
Sent: Monday, April 24, 2006 10:09 AM
To: [email protected]
Subject: ]] XL-mania [[ Grand Total Formula

Dear XL-Mania,
 
Saya ada masalah untuk menjumlahkan beberapa subtotal.
Permasalahnya seperti ini:
 
Kolom B    Kolom C

Data

Jumlah

Xyz

10

Yxz

20

Subtotal

30

--> SUBTOTAL(9,C2:C3)

Zyx

20

Abc

5

Bcd

10

Subtotal

35

Grandtotal

       ??

--> pakai rumus apa ya?

 
Mohon bantuannya dan terima kasih banyak.
 


-----------------------------------------------------------------------------------
PRIVILEGED AND CONFIDENTIAL (Disclaimer)
-----------------------------------------------------------------------------------
 This e-mail message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure. If you are not the intended recipient, please do not disseminate, distribute, or copy this communication, by e-mail or otherwise, or take any action in reliance on it. Instead, please notify us immediately by return e-mail (including the original message in your reply) to [EMAIL PROTECTED], and then delete and discard all copies of the e-mail.


+-:: XL-mania ::::::::::::::::::::----------------------------------+
|                                                                   |
| 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  |
| [EMAIL PROTECTED] atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni Anda tentang XL-mania di :                      |
| http://www.friendster.com/profiles/xlmania                        |
+-------------------------------------------------------------------+


YAHOO! GROUPS LINKS



Kirim email ke