Countif – Nested conditions

5.37K 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

S A U Answered question March 7, 2019

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),

braddo Posted new comment July 20, 2020

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.

Latest Questions