don't forget my nickname, ZAMPRODUCT

 

=SUMPRODUCT((F7:V7=$Z$7:$Z$10)*$AA$7:$AA$10)

 

-zam-

 <http://wongmbatu.blogspot.com/> http://wongmbatu.blogspot.com/

 

  _____  

From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf
Of Wahyu Widiantoro
Sent: Wednesday, August 27, 2008 11:10 AM
To: [email protected]; [EMAIL PROTECTED]
Subject: ]] XL-mania [[ cara mencari penjumlahan huruf yg dikonversi ke
angka

 

Dear sesepuh excel semua,

 

bagaimana cara mencari penjumlahan huruf yg hasil akhirnya dikonversi ke
angka sesuai kasus berikut? 

 

terimakasih banyak

 

~Widi~

Kirim email ke