How to omit blank cells when calculating weighted averages

[T. Valko]

Assuming the numbers are all positive:

=SMALL(A1:A10,COUNTIF(A1:A10,0)+1)