Forum Discussion

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

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
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
  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
  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
    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