# Excel weighted average with missing values

Describes the cause and action for error messages.

Error Message(English)：
weighted average with missing values

## 関連リンク

How to ignore blanks when calculate the weighted average in Excel?
https://www.extendoffice.com/documents/excel/4207-excel-weighted-average-ignore-blanks.html

How to calculate weighted average in Excel (SUM and ... - Ablebits.com

How to calculate weighted average for 0 values - Stack Overflow
https://stackoverflow.com/questions/39222679/how-to-calculate-weighted-average-for-0-values

Weighted mean calculation in R with missing values
https://stackoverflow.com/questions/46517425/weighted-mean-calculation-in-r-with-missing-values

Weighted average value in the presence of NA values
https://stackoverflow.com/questions/40541172/weighted-average-value-in-the-presence-of-na-values

Excel formula -> how to change SUMPRODUCT formula to skip ...
https://stackoverflow.com/questions/18609922/excel-formula-how-to-change-sumproduct-formula-to-skip-・・・

Creating a Weighted Average - Dropping Weights for NULL ...
https://stackoverflow.com/questions/15164707/creating-a-weighted-average-dropping-weights-for-null-v・・・

Weighted average, ignoring blank cells and avoiding the #DIV/0 ...
https://superuser.com/questions/1057051/weighted-average-ignoring-blank-cells-and-avoiding-the-div-0・・・

algebra precalculus - Determining a Missing Data Value in Weighted ...
https://math.stackexchange.com/questions/2072810/determining-a-missing-data-value-in-weighted-averag・・・

AVERAGE.WEIGHTED function - Docs Editors Help - Google Support