I've used sumproduct and array formulas before, but does anyone know how to calculate a non-zero weigthted average in Excel for a range of numbers? Thanks for the help.