G
Guest
Has anyone experienced any substantial errors from the Countifs Formula?
A B C
1 15 51 30
3 20 30 18
4 20 15 18
5 15 51 30
COUNTIFS(A3:C3,A1,A4:C4, B1,A5:C5, C1) = 0 when it should equal 1
Is my syntax wrong? This what the formula produces?
Any ideas?
A B C
1 15 51 30
3 20 30 18
4 20 15 18
5 15 51 30
COUNTIFS(A3:C3,A1,A4:C4, B1,A5:C5, C1) = 0 when it should equal 1
Is my syntax wrong? This what the formula produces?
Any ideas?