assume the weights are in B1:B100
=sumproduct(A1:A100,B1:B100)/sum(B1:B100)

--
Regards,
Tom Ogilvy


"James" wrote in message
. ..
It is easy enough to find simple average with =average(a1:a100)

What is the easiest way to find a average?

Thanks

James