Tuesday, October 11, 2011

yogi_Count Cells Filled In A Column That Are Not In Another Specified Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
a user said:
Count cells filled in column A that are not in B, and vice-versa
I happen to have columns A and B, each filled with “X”s:

A B
X
X
X X
X
X
X
X X

How do I count the number of cells filled in A that are not in B, and vice-versa? There is this undocumented Google Docs function, but I couldn’t understand how it works: COUNTUNIQUE().
For A it should be 3, and for B just 2.
----------------------------------------