Resolve #DIV/0 errors in Excel weighted harmonic mean calculations caused by zero weights or missing data using IFERROR or SUMPRODUCT.