Hello,

I'm trying to compute CHITEST for several subsets inside the same sheet. But there is some problem when I combine CHITEST and IF:

Writing:
{=IF($A$2:$A$1606=$A2,$U$2:$U$1606)}
I get: {2,1,1,0,1}
(values in U2:U6)

But if I write:
{=CHITEST((IF($A$2:$A$1606=$A2,$U$2:$U$1606)),{1,1,1,1,1})}
I get: #N/A

However, writing:
=CHITEST({2,1,1,0,1},{1,1,1,1,1})
or
=CHITEST(U2:U6,{1,1,1,1,1})
I get: 0.73


Any idea?

(I'm using Office 2008 for Mac)

Thank you in advance.