Countif – Nested conditions

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
1.83K 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),

Posted new comment

Notice: compact(): Undefined variable: groupby in /home/quantrixwebsite/public_html/answers/wp-includes/class-wp-comment-query.php on line 853

I have also found that the traditional spreadsheet functions countif, sumif slow down performance considerable. Counta with a select is much faster.

0

Attach an example of what you need.

Posted new comment

Thank you so much SAU; problem solved combining the Countif formula with Using as.

Regards