Forum Discussion
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...
Hi SergeiBaklan please find attached a copu of the Worksheet, where I try to use an dynamic list,instead of fixed values.
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.
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
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.