Hello,
I'm having issues with a COUNTIFS formula...I'm using the below
=COUNTIFS($CT$6:$CT$7666,"P1",$X$6:$X$7666,{"x","+"})
this returns a result of 166, however when I filter on the above criteria "P1" and {"x","+"} I'm showing 217
Any ideas why this would not be working?
Thanks in advance,
John
I'm having issues with a COUNTIFS formula...I'm using the below
=COUNTIFS($CT$6:$CT$7666,"P1",$X$6:$X$7666,{"x","+"})
this returns a result of 166, however when I filter on the above criteria "P1" and {"x","+"} I'm showing 217
Any ideas why this would not be working?
Thanks in advance,
John