Sumproduct and filters

  • Thread starter Thread starter Niller
  • Start date Start date
N

Niller

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.
 
It might help if you tell us what you think your formula is attempting to
do.
 
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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to sumproduct only filtered data 25
sumproduct with wildcard for text? 4
Wildcard in SumProduct 3
SUMPRODUCT query 10
Need help with "Function to do what auto-filter does" 3
Sumproduct with filters 7
Row Limitation in SUMPRODUCT 2
Conditional SUMPRODUCT or SUMPRODUCT with Filters 4

Back
Top