Counting criteria and blanks

Ronald Anderson

How would this be modified this to allow for counting both yes and blanks?

=COUNTIFS({Operation}, [Column2]@row, {Assigned}, "Yes")

Bassam Khalil

Hi @Ronald Anderson 

Hope you are fine, please try the following formula:

=COUNTIFS({Operation}, [Column2]@row, {Assigned}, and(@cell="Yes",@cell = ""))

Bassam Khalil

Hi @Ronald Anderson 

Hope you are fine, please try the following formula:

=COUNTIFS({Operation}, [Column2]@row, {Assigned}, and(@cell="Yes",@cell = ""))

Ronald Anderson

Thank you for your help. I changed AND to OR and it does what I need.

Bassam Khalil

@Ronald Anderson

Excellent