Hi,

thanks for the help, the YesNo Range results in 2418 compared to the other two, which result in 2416.

Too bad the data is confidential, otherwise I would past it here. I cant seem to find the errornous cell or anything, but since there is data in every column Ive just replaced the Range for YesNo to the following:

=OFFSET('Input Ret Suc'!$E$1;0;0;COUNTA('Input Ret Suc'!$B:$B);1)

And it solved the problem. Thanks a lot for the help. It really helped a lot.