Hi!
I need to perform a T-Test between two groups of values that can be
held in non-contiguous ranges, is this possible?

For example the two groups for the T-Test could be:
group1: A1:A3,A5:A6
group2: B1:B6

When I define the ranges for the ttest using Excel's "formula editor" I
get the following for the result cell:
=TTEST(A1:A3,A5:A6,B1:B6,2,3)

The above generates an error saying that to many arguments have been
entered. I have tried to enclose the non-contiguous range in different
ways using () and {} which doesn't work. I have also tried using a
named ranges, but without luck.

In the formula editor, the groups for the T-test are called Array1 and
Array2, does the problem have to do with defining arrays?

Any help would be appreciated.

Regards,
Kristina