Ok, so I have data in this format:
A B C D
2 X X X
3 X X
4 X X X
5 X
6 X X
...
I have a formula that helps with a total count per column:
=COUNTA(A2:A)
But how do I calculate “exclusives”? In this case, the expected answer for A, C & D is 0, while B should yield 1 (row 5).
The results will be laid out per column, so my pseudocode logic for column B would be:
if (count(A)=0 and count(C)=0 and count(D)=0)
then count(B)
Alternatively:
count(b) where count(a)=0, count(c)=0, count(d)=0
Is my logic correct in the given context (Google Sheets)? What formula (or combinations of formulae) would I need to achieve the desired result in Google Sheets?
Edit: I'm using named ranges in my sheet, just in case that makes a difference as far as the formula is concerned.