hat
Pou egzanp, gen de kolòn nan yon fèy ki ekri nòt yo ak kantite ka yon elèv, men elèv sa a se absan nan kèk ka nan egzamen ki kite espas vid yo nan kolòn nan klas tankou anba a Ekran yo montre. Si ou aplike fonksyon nòmal Pwa Mwayèn =SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5), li pral jwenn rezilta 79.333 ki se yon ti jan enjis pou elèv la. Nan atik sa a, mwen prezante yon fòmil pou kalkile mwayèn filye yo inyore dosye vid nan Excel.
eng
For example, there are two columns in a sheet which record the grades and the number of cases of a student, but this student is absent from some cases of examinations which leave the blanks in the column of grades as below screenshot shown. If you apply the normal Weighted Average function =SUMPRODUCT(A2:A5,B2:B5)/SUM(B2:B5), it will get the result 79.333 which is somewhat unfair for the student. In this article, I introduce a formula to calculate the weighted average ignoring blank records in Excel.