How do you count the number of rows when you have multiple non-continues selections

Well, it worked for me?? - The reason to remove the value qualifier is that you're replacing the whole range and the whole range has no distinct value i.e. it's inappropriate