Snasui Excel Forum

Hi Dear

I need your help to count 1,"." and empty "" in the range returning value by columns

I want the result to show 1 if count criteria 1 ,"." dot and empty "" greater than 1 return 1 otherwise 0.

Best Wishes

=COUNTIFS(F4,"<>A")