hat
Chwazi yon selil vid ou vle mete rezilta a, epi tape fòmil sa a =SUMPRODUCT(A2:A5,$B$2:$B$5)/SUMPRODUCT(--(A2:A5<>""),$B$2:$B$5), ak laprès Antre kle. Al gade nan Ekran:
eng
Select a blank cell you want to place the result, and type this formula =SUMPRODUCT(A2:A5,$B$2:$B$5)/SUMPRODUCT(--(A2:A5<>""),$B$2:$B$5), and press Enter key. See screenshot: