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 ...
Formulas and Functions
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

DrAntAbs's avatar
DrAntAbs
Copper Contributor
Mar 30, 2020

Abiola1  thanks for getting back to me.

 

I've attached an example of the document.

 

For example I want to get the total number of MBRAFQ that are GA2001.

  • 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 

     

     

  • Abiola1's avatar
    Abiola1
    MVP
    Mar 30, 2020

    DrAntAbs 

     

    Hello, I have seen your data. Although, the spreadsheet wasn't well designed because headings in row 4 are missing. Kindly let me know which column you want to count

     

     

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

      Abiola1  The heading ALL PROCEDURE CODES applies to columns B-K and ALL DIAGNOSIS CODES applies to columns M-V. 

       

      So I want to count all MBRAFQ in B-K that are GA201 IN M-V.

       

      I hope that makes sense please sir.

       

      Thanks 

Resources