Coba formula ini:

untuk kolom "B":
= SUMIF($A$3:$A$50;$A54;B$3:B$50) + SUMIF($A$3:$A$50;$A54+(1/48);B$3:B$50)


Iseng


________________________________
 From: Yedi Noorhikmah <[email protected]>
To: [email protected] 
Sent: Wednesday, May 23, 2012 2:44 PM
Subject: ]] XL-mania [[ Menjumlahkan Per 2 Cell
 

  
Dear Master XL,

Mohon bantuannya untuk formula penjumlahan per 2 Cell Xl (seperti Terlampir)

Regard's


Yedi 



 

Kirim email ke