Hi,

=CHITEST(data1,data2) where data1 and data2 don't include totals.

The returned test statistic approaches 1 as the data sets become less independent.