J James Dec 19, 2003 #1 It is easy enough to find simple average with =average(a1:a100) What is the easiest way to find a average? Thanks James
It is easy enough to find simple average with =average(a1:a100) What is the easiest way to find a average? Thanks James
T Tom Ogilvy Dec 19, 2003 #2 assume the weights are in B1:B100 =sumproduct(A1:A100,B1:B100)/sum(B1:B100)
