Very cool, thanks.
If you have an extra moment, could you explain this. That would be a great
help as I am attempting to master the very versitile Sumproduct function, and
have made strides, but obviously still need to study further.

Thank you

"Gary''s Student" wrote:

=SUMPRODUCT((G2:G9075<"")/COUNTIF(G2:G9075,G2:G9075&""))
--
Gary''s Student - gsnu200815