Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weighted Average across worksheets
I am aware of the technique using sumproduct to calculate a weighted average
figure, but this doesn't appear to work across worksheets. I have 12 worksheets named P1 - P12 and am trying to calculate a weighted average of the cells K2 and L2 on each sheet The formula =SUMPRODUCT('P1:P12'!L2,'P1:P12'!K2) / SUM('P1:P12'!K2) returns #REF! Can anyone help please. Allan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Average across worksheets | Excel Worksheet Functions | |||
How do I weighted average using Pivot Tables? | Charts and Charting in Excel | |||
weighted average formular | Excel Worksheet Functions | |||
weighted average | Excel Discussion (Misc queries) | |||
Show weighted average value after filter. | Excel Worksheet Functions |