Useing data from defferent workbook

[emukiss10]

Hello,

I have a little problem. I have a large statistic table in one WB and in a different WB references to the first one. When I open my second WB i see #ARG ! in every cell, but when I open both the values are displaying properly.

Can I somehow fix it so that values would be correct if only second WB was opened?

Best Regards
W.

 

[FormR]

Not tested, but you could try this instead, note: you'll probably need to translate SUMPRODUCT to your local language.

=SUMPRODUCT([STAT.xlsm]Licznik!$T$2:$T$50000;--([STAT.xlsm]Licznik!$R$2:$R$50000=$A$4);--([STAT.xlsm]Licznik!$B$2:$B$50000=C$2);--([STAT.xlsm]Licznik!$J$2:$J$50000>=0+"2017-09-01");--([STAT.xlsm]Licznik!$J$2:$J$50000<=0+"2017-09-30"))

 

[emukiss10]

It works! Can You tell me what "--" does in this formula?

 

[FormR]

Can You tell me what "--" does in this formula?

Hi, it converts the array of TRUE / FALSE values that are returned from the logical tests to 1's and 0's.

If you do an internet search for "Excel + double unary + sumproduct" you should be able to dig out some more detailed explanations.