Ztest and multiple arrays of data?

Originally Posted by daffodil11

Have you tried selecting just those cells and naming the range?

And then referencing the named range instead?

Never thought of that, I'll give it a try.

Tried it out, it did not work. Tried creating the name and clicked "Use in Formula" but it did not work....