Forum Discussion
COUNTIFS?
=COUNTIFS(MATCHES!$E$9:$E$999,">0")
and
=COUNTIFS(MATCHES!U$9:U$999,20)
work fine, but
=COUNTIFS(MATCHES!$E$9:$E$999,">0",MATCHES!U$9:U$999,20)
doesn't.
What am I doing wrong?
2 Replies
Hi,
Strange, what exactly doesn't work? Shall return number of all combinations where E values are positive and U ones are equal to 20.
Oops! I had the cells in question formatted as text instead of general. Now it works.
Thanks.
