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

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.

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