=COUNTIF field has any value

Kyler Keel

Hello, 

My current incorrect statement is as follows: 

=COUNTIF(Plant:Plant, "DC", [Assigned To]:[Assigned To], NOT(ISBLANK([Assigned To]:[Assigned To])))

I am attempting to count the number of fields with any value in the "Assigned To" column with the plant column being "DC". 

I have made numerous failed attempts to find help with this by reading current info.

Any help would be greatly appreciated.  

Andrée Starå

Hi Kyler,

I'd recommend using the COUNTIFS function instead.

Try something like this.

=COUNTIFS(Plant:Plant; "DC"; [Assigned To]:[Assigned To]; NOT(ISBLANK(@cell)))

The same version but with the below changes for your and others convenience.

=COUNTIFS(Plant:Plant, "DC", [Assigned To]:[Assigned To], NOT(ISBLANK(@cell)))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

Yes. COUNTIFS and replacing the range within your NOT(ISBLANK()) with an @cell reference.