Counting criteria and blanks

Ronald Anderson · 10/08/21

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

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

Bassam Khalil · 10/10/21

Hope you are fine, please try the following formula:

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

Bassam Khalil · 10/10/21

Hope you are fine, please try the following formula:

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

Ronald Anderson · 10/10/21

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

Bassam Khalil · 10/11/21

Excellent

Best Answer