Weighted Average with criteria

Hi All,
On the attached sheet I want an average age weighted by the number for each variation of Star rating. I would normally use a SUMPRODUCT for a weighted average, but without going through and placing them so all the stars are together I do not know how I would do this. I am using Excel 2003.

Any ideas?

Thanks very much
Richard.

If I've understood

Please Login or Register  to view this content.