RE: [belajar-excel] Mencari rata-rata persentase

Tue, 13 Sep 2011 21:09:01 -0700 

Mr Kid, 

Thanks untuk formulasinya. 

Salam. 

  _____  

From: [email protected] [mailto:[email protected]]
On Behalf Of Mr. Kid
Sent: Tuesday, September 13, 2011 2:38 PM

Hai Budhi,

Sheet1.
=IF(A2<"T",6,3)%*(B2+C2)

Sheet2. Array Formula (jangan lupa CSE)
=AVERAGE(IF($B$3:$M$3=B$14,$B4:$M4/$D4:$O4))

Salam.
Kid.

Kirim email ke