Tecnologia, programação e muito Visual FoxPro.

quarta-feira, 2 de junho de 2010

Re: ]] XL-mania [[ Menghitung GR

 

Count(D#:D#) dengan asumsi kolom No di kolom A.
jika data mulai baris 11 sampai 111, menjadi Count(D11:D111)

Kid


2010/6/2 Dewanto Agung Budiman <dewanto.budiman@ag-it.com>

Dear Para Pakar XL

 

Saya punya case seperti ini.

 

Biasaya dalam penjumlahan kita bisa itung menggunakan "sumproduct"

 

Tapi bila itu bentuknya nomor dan bukan text bagaimana yah?

 

Mohon di bantu.

 



Kind regards

Dewanto

 

Astra Graphia Information Technology

Warehouse Kelapa Gading

Komp. Pergudangan BGR Blok I no. 4

Jl. Boulevard BGR no. 1, Jl. Perintis Kemerdekaan, Kelapa Gading Barat, Jakarta Utara 14210

Mobile       : +62 838-9207-2203

Phone        : +62 (21) 45848035/34

Facsimile    : +62 (21) 4534064

Homepage http://www.ag-it.com

 


__._,_.___
Recent Activity:
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| momod akan terdampar seminggu lagi, moderasi akan lemodmod...     |
| hidup tanpa google dan fesbuk dan yahuuuu... ampun dehhh...       |
| 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

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.


Get great advice about dogs and cats. Visit the Dog & Cat Answers Center.


Get real-time World Cup coverage on the Yahoo! Toolbar. Download now to win a signed team jersey!

.

__,_._,___

Nenhum comentário:

Arquivo do blog