Countif doesnt work across sheets

[idont]

Hi,

=ANTALL.HVIS(Bruker0:Bruker150!E5;"1")

Translated to english Excel:

=COUNTIF(Bruker0:Bruker150!D13,"1")

This doesnt work:

On the shetts Bruker0, 1, 2.. I Got a value in the D13 that range between 0 to 5. I want it to sum up the numbers, in the case over, 1 and tell me how many 1 there are.

My sheet line looks like this:

http://prntscr.com/oq16b1

When i Hit enter, it only says #VALUE ! (or #VERDI ! in .no).

Any ideas?

 

[Special-K99]

That's called a 3D Reference and though SUM works, COUNTIF does not.

There's a solution here

https://www.mrexcel.com/forum/excel...-am-i-getting-error-countif-3d-reference.html