Ignore Hidden Rows with TTest

[Yser]

Hi,

I'd like to have Ttest ignore hidden rows.

Normally: =TTest(A1:A10,A11:A20,2,3)
would compare group 1 (A1 to A10) with group 2 (A11 to A20)

but how to ignore hidden rows?

I know the function SUBTOTAL can ignore hidden cells but the function used in subtotal does not have TTest.

Please advise. Thanks.

 

[Domenic]

Try...

=TTEST(IF(SUBTOTAL(103,OFFSET(A1:A10,ROW(A1:A10)-ROW(A1),0,1)),A1:A10),IF(SUBTOTAL(103,OFFSET(A11:A20,ROW(A11:A20)-ROW(A11),0,1)),A11:A20),2,3)

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.