Excel question about the ztest function

[cutchemist42]

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. The Excel formula and how it works is not letting me exclude A3.


Thanks for any help!

[froment]

When you select those two ranges holding Ctrl, formula becomes

=ZTEST(A1:A2,A4 ...

So Excel assumes coma (or semicolon, depending on your keyboard settings) separates arguments of the function, so it thinks A4 is x value rather than part of the range. So, try to enclose range in parenthesis:

=ZTEST((A1:A2,A4),x)