Trying to make the Ztest formula work, and normally I know how to but not in this situation, it keeps giving me the #value sign. I'm trying to do a Ztest for a certain array of numbers that excludes some cells. For example.


A1
A2
A3
A4


I am trying to do a ztest only on the values in A1, A2, and A4 while excluding A3. (In actuality, I'm trying to do something like this over 160 cells) The Excel formula and how it works is not letting me exclude A3.


Thanks for any help!