Forum Discussion

DrAntAbs's avatar
DrAntAbs
Copper Contributor
Mar 30, 2020

Help with Countif with multiple criteria

Good morning,

I am working on an excel document and want to use the COUNTIFS option to help me get some data. However I keep getting an error message although I am putting in the right formula. Any help appreciated. 

Formulas and Functions

10 Replies

  • Abiola1's avatar
    Abiola1
    MVP
    Mar 30, 2020

    DrAntAbs 

     

    Hello, 

    Although, I can't see your data, but I believe you can use PivotTable to achieve the count you want. If possible to upload the file or a sample file, I can show you how to achieve your desire report

      • Abiola1's avatar
        Abiola1
        MVP
        Mar 30, 2020

        DrAntAbs 

        Below is a classical example of how to design spreadsheet. All the headings should be visible and there shouldnt be empty cells/columns/rows without data. This makes it easily to use myriads of Excel functionalities 

         

         

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 30, 2020

    DrAntAbs 

    I may only confirm that COUNTIFS() in Excel works correctly - millions of people around the globe use it and have correct results.

     

    It's hard to say what's wrong in your case without concrete example.

    • DrAntAbs's avatar
      DrAntAbs
      Copper Contributor
      Mar 30, 2020

      SergeiBaklan Many thanks for getting back to me sir.

       

      The issue is this,

      I want to count the number of tests were positive for a particular test out of about 400 sample cohort. I therefore used COUNTIFS where I set first range,then the first criteria (excel gives me a value for this first part) but when I set the second range and second criteria, I get a 0.

       

      I have used the COUNTIFS function already as part of the audit I am doing so I know it should work, I just don't know why this one isn't. 

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Mar 30, 2020

        DrAntAbs 

        Again, the question is a bit abstract. Perhaps you may provide some sample of not working properly function? 

Resources