Forum Discussion
Count columns contain data
Hello guys, i'm searching for some help with an Excel template, what I need in specific is to get or count columns instead of cells. I will try to explain my concern... in the excel file attached (Sa...
I'd use a helper row. In the attached version, I used row 21, but it can be any row.
A21 contains the formula =COUNTIF(A8:A20,"<0.118")+COUNTIF(A8:A20,">0.182") and this has been copied to C21, E21 etc.
The formula to count the number of columns with NOK is =COUNTIF(21:21,">0")
HansVogelaar Hi, i really appreciate your support and quick contribution... awesome! I will use it the formula thanks a lot!