Selamat Pagi, Salam kenal, (member baru)
Saya punya data pengeboran tanah seperti berikut : ---+---A------+---B--------+--C--------+----D--------------+--- 1---+-Hole_ID-+-Tipe-+---Tebal---+-Kadar-+-Kadar Rata2 --+--- 2---+-PA01----+-BS----+---1.5-----+--40---+-----40.50-----------+--- 3---+-PA01----+-BS----+---0.5-----+--42---+------------------------+--- 4---+-PA01----+-GR----+---1.5-----+--47---+-----47.82-----------+--- 5---+-PA01----+-GR----+---1.5-----+--48---+------------------------+--- 6---+-PA01----+-GR----+---0.8-----+--49---+------------------------+ 7---+-PA01----+-YS----+---1.5-----+--48---+-----49.19--------------+--- 8---+-PA01----+-YS----+---1.5-----+--48---+------------------------+--- 9---+-PA01----+-YS----+---1.5-----+--48---+------------------------+--- 10--+-PA01----+-YS----+---1.5-----+--48---+------------------------+--- 11--+-PA01----+-YS----+---1.5-----+--50---+------------------------+--- 12--+-PA01----+-YS----+---0.5-----+--49---+------------------------+--- 13--+-PA01----+-GS----+---1.5-----+--30---+-----30.24--------------+--- 14--+-PA01----+-GS----+---0.2-----+--32---+------------------------+--- 15--+-PA02----+-BS----+---1.5-----+--40---+-----41.14--------------+--- 16--+-PA02----+-BS----+---1.5-----+--42---+------------------------+--- 17--+-PA02----+-BS----+---0.5-----+--42---+------------------------+--- 18--+-PA02----+-GR----+---1.5-----+--48---+-----47.70--------------+--- 19--+-PA02----+-GR----+---0.8-----+--49---+------------------------+ 20--+-PA02----+-YS----+---1.5-----+--48---+-----49.30--------------+--- 21--+-PA02----+-YS----+---1.5-----+--48---+------------------------+--- 22--+-PA02----+-YS----+---1.5-----+--48---+------------------------+--- 23--+-PA02----+-YS----+---0.5-----+--48---+------------------------+--- 24--+-PA02----+-GS----+---1.5-----+--30---+-----30-----------------+--- > > > 2000 --+ PA200 +-BS.dst. . . Secara Manual saya membuat formula untuk setiap Kadar Rata2 per litho seperti ini : Cell D2 diisi : =SUMPRODUCT(B2:B3*C2:C3)/SUM(B2:B3) Cell D4 diisi : =SUMPRODUCT(B4:B6*C4:C6)/SUM(B4:B6) Cell D7 diisi : =SUMPRODUCT(B7:B12*C7:C12)/SUM(B7:B12) Cell D13 diisi : =SUMPRODUCT(B13:B14*C13:C14)/SUM(B13:B14) Cell D15 diisi : =SUMPRODUCT(C15:C17*D15:D17)/SUM(C15:C17) Cell D18 diisi : =SUMPRODUCT(C18:C19*D18:D19)/SUM(C18:C19) Cell D20 diisi : =SUMPRODUCT(C20:C23*D20:D23)/SUM(C20:C23) Cell D24 diisi : =SUMPRODUCT(C24:C24*D24:D24)/SUM(C24:C24) Tanya : Adakah Formula alternatif untuk menghitung kadar rata dengan kriteria nam Tipe ? mengingat data saya ada ribuan baris, sehingga repot kalau harus dengan cara diatas (contoh file terlampir) Terima kasih Salam, Dody
Weighted Average dengan Kriteria.xlsx
Description: x-unknown/unknown
