Countif – Nested conditions

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
1.65K viewsFormulas and Functions

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

Answered question

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!

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