Forum Discussion

Iron Contributor

Jun 05, 2020

Sumifs with a dynamic list criteria

Hi I am trying to use Sumifs ehre one of the criteria is from a dynamic list. It fills down the correct number of rows, but only choose the first item from the dynamic list. Command: =SUMI...

excel

Formulas and Functions

SergeiBaklan

Diamond Contributor

Jun 05, 2020

Hogstad_Raadgivning

Geir, perhaps you may illustrate on the sample file, not on screenshot what's wrong. Here it looks like works:

File is attached.

Dynamic SUMIFS.xlsx19 KB

Hogstad_Raadgivning

Iron Contributor

Jun 05, 2020

Hi SergeiBaklan please find attached a copu of the Worksheet, where I try to use an dynamic list,instead of fixed values.

sumifex.xlsx21 KB

SergeiBaklan
Diamond Contributor
Jun 05, 2020
Hogstad_Raadgivning

I see. Please remove sheet name from the spill reference

when it'll be like

I do one by one it's the same result.
sumifex.xlsx21 KB
- Hogstad_Raadgivning
  Iron Contributor
  Jun 05, 2020
  The function is correct SergeiBaklan 🙂 I did a double check with fixed values. And they do have the same values. Sorry. I used RANDARRAY to generate numbers. And I did not think it would be some identical numbers there, for the same product.
  
  Thank you for helping.
  
  - Geir
  - SergeiBaklan
    Diamond Contributor
    Jun 05, 2020
    Hogstad_Raadgivning , you are welcome
    
    To be more clear, you may use Selgere!B20# or B20#, result will be exactly the same. Just for the formula in first case only first cell will be highlighted in the spill and in second case entire spill.