Countifs with table references not working

[Pauleyb]

Attached document should show the problem, but column BN has:

=COUNTIF(Table1[[#This Row],[10/31]:[1/2]],"x")+COUNTIFS(Table1[[#This Row],[10/31]:[1/2]],"a",Table1[[#This Row],[10/31]:[1/2]],"p")/2

which ignores cells that has "a" or "p" in it. I believe it should be counting them.

Changing the code to:

=COUNTIF(Table1[[#This Row],[10/31]:[1/2]],"x")+COUNTIFS(B2:BM2,"a",B2:BM2,"p")/2

Works as expected.

Theories?

Pauley

[Pauleyb]

Actually, the second one doesn't work. I'm missing something obvious with my countifs syntax.

Investigating...

Pauley

[Pauleyb]

Never mind. Using Countifs incorrectly.

Pauley