Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weighted Average Question
It is easy enough to find simple average with =average(a1:a100)
What is the easiest way to find a average? Thanks James |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Weighted Average Question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Weighted Average | Excel Discussion (Misc queries) | |||
weighted average | Setting up and Configuration of Excel | |||
Need help with weighted average | Excel Discussion (Misc queries) | |||
Weighted average question | Excel Worksheet Functions | |||
Weighted Average | Excel Worksheet Functions |