Sumifs with a dynamic list criteria

Question

Hi&nbsp;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.&nbsp;&nbsp;Command:&nbsp;=SUMIFS(Tabell1[Omsetning];Tabell1[Selger];Selgere!B20#;Tabell1[Kvartal];2;Tabell1[Produkt];Selgere!$B$16)&nbsp;The list starting in B20 is buildt with Sort(Unic function.All numbers is for "Hansen" Any solution for this?&nbsp;Best Regards- Geir&nbsp;

sergeibaklan · Answer

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

File is attached.

jos_woolley · Answer

Hogstad_Raadgivning&nbsp;&nbsp;Looks fine syntactically to me. Can you upload a workbook?&nbsp;Regards

sergeibaklan · Answer

Hogstad_Raadgivning&nbsp;
I update criteria with spill, the same
&nbsp;

sergeibaklan · Answer

Hogstad_Raadgivning&nbsp;
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.

hogstad_raadgivning · Answer

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

Forum Discussion

Sumifs with a dynamic list criteria

9 Replies

Resources