Countif – Nested conditions

2.00K viewsFormulas and Functions
0

Hi all,
I’m trying to count the using “Countif” based on two conditions.
Example: countif column A = “Active” and column B = “ Funcional”
It should be a nested formule just like the Excel’s “countifs”
Thank you so much
Carlo

Answered question
0

Since Carlo does not provide an example of what he wants to get, I give the answer to the question as I understood:
*
how to use CountIf() to sample data from one matrix according to two criteria?
*
The answer to this question is in the attached model file.
*
*
Good luck!

Posted new comment

Excuse me SAU but I remember to have answered you that I solved with the combination of COUNTIF and USING AS functions.
If not, please excuse me.
Carlo

You are viewing 1 out of 3 answers, click here to view all answers.