Countif – Nested conditions

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
688 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!

Answered question
0

I find select (and selectslike, etc.) in combination with counta work better than countif. You can also combine with switch. Example:
if(counta(select(Ships:Calls[FIRST] .. Ships:Calls[LAST],Ships:Calls[FIRST] .. Ships:Calls[LAST],Ships))>=15,0.15,counta(select(Ships:Calls[FIRST] .. Ships:Calls[LAST],Ships:Calls[FIRST] .. Ships:Calls[LAST],Ships))/100),

Answered question
0

Attach an example of what you need.

Answered question

Latest Questions