| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct seems off... HELP PLEASE!
WinXPPro SP3, Excel 2k
OK so I'm using sumprod and something just doesn't seem right. Col B should clearly have a higher weighted average than Col C. Can anyone see what's wrong, or should I just pack up and go home for the day! :-) 29.00% 5 3.3 71.00% 5 4 WA: 1.45 3.80 Col B formula: SUMPRODUCT(B1:B2,$A$1:$A$2) Col C formula: SUMPRODUCT(C1:C2,$A$1:$A$2) -- Hile |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
| SumProduct Help | Excel Discussion (Misc queries) | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| SumProduct? | Excel Worksheet Functions | |||
| sumproduct? sumif(sumproduct)? | Excel Worksheet Functions | |||
Threaded Mode
