SOLVED

counta with ifthen

Brass Contributor

I want to count the number of cells that are not blank.  If that number is 2, return Yes.  If not 2, then No

2 Replies
best response confirmed by Bryan123 (Brass Contributor)
Solution

@Bryan123 

=IF(COUNTA(A1:F1)=2,"Yes","No")

Maybe with this formula as shown in the attached file. 

Thank you

Had a brain freeze!
1 best response

Accepted Solutions
best response confirmed by Bryan123 (Brass Contributor)
Solution

@Bryan123 

=IF(COUNTA(A1:F1)=2,"Yes","No")

Maybe with this formula as shown in the attached file. 

View solution in original post