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

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.

Jan 19 Data.xlsx53 KB

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