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

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

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

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