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. ----------------------------------------
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. ----------------------------------------
No comments:
Post a Comment