Forum Discussion

piney29887's avatar
piney29887
Copper Contributor
Apr 02, 2017

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?
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 02, 2017

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.

  • piney29887's avatar
    piney29887
    Copper Contributor
    Apr 03, 2017

    Oops! I had the cells in question formatted as text instead of general. Now it works.

    Thanks.

Resources