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:
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)
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.