如题所述
å æå¹³åæ°çå ¬å¼ä¸ºï¼
=SUMPRODUCT(B2:B4,C2:C4)/SUM(B2:B4)
æè è¾å ¥å ¬å¼ï¼=SUM(B2:B4*C2:C4)/SUM(B2:B4)
ç¶åæä¸Ctrl+Shift+Enterä¸é®ç»ææ°ç»å ¬å¼çè¾å ¥ã