Forum Discussion
Solved
Count the occurrence of 3's and 4's in a column with hidden rows
In excel if you want to count the occurrence of two numbers in a column you can use: =COUNTIF(Table13[Amada],3)+COUNTIF(Table13[Amada],4) and that will return the number of times that the dig...
If you have access to LAMBDA:
=COUNT(IF(SCAN(,Table13[Amada],LAMBDA(a,b,IF(SUBTOTAL(102,b)>0,b,0)))={3,4},1))
If you have access to LAMBDA:
=COUNT(IF(SCAN(,Table13[Amada],LAMBDA(a,b,IF(SUBTOTAL(102,b)>0,b,0)))={3,4},1))- This works great,
Thank you!
