Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct and filters
Hi,
being quite new to the world of sumproducts I struggle to find a formula that works when filtering. The formular I am currently using is: =SUMPRODUKT($BJ$2:$BJ$462;BS2:BS462) I'll be glad for any help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct and filters
It might help if you tell us what you think your formula is attempting to
do. -- Rick (MVP - Excel) "Niller" wrote in message ... Hi, being quite new to the world of sumproducts I struggle to find a formula that works when filtering. The formular I am currently using is: =SUMPRODUKT($BJ$2:$BJ$462;BS2:BS462) I'll be glad for any help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct and filters
Of course. It is calculating weighted averages. BJ consist of relative
importance data, and BS of performance. (There is a number of colums having similar formulars, i.e. BK and BT, respectively.) The $ is used as the relative importance data is applied to different performance sets. Niller "Rick Rothstein" skrev: It might help if you tell us what you think your formula is attempting to do. -- Rick (MVP - Excel) "Niller" wrote in message ... Hi, being quite new to the world of sumproducts I struggle to find a formula that works when filtering. The formular I am currently using is: =SUMPRODUKT($BJ$2:$BJ$462;BS2:BS462) I'll be glad for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct with filters | Excel Worksheet Functions | |||
Sumproduct & Filters | Excel Discussion (Misc queries) | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
Filters, Subtotal & Intacted Results after the filters' Removal | Excel Discussion (Misc queries) |