Apr 26 2022 01:02 PM
I want to count the number of cells that are not blank. If that number is 2, return Yes. If not 2, then No
Apr 26 2022 01:11 PM
SolutionApr 26 2022 01:11 PM
Solution=IF(COUNTA(A1:F1)=2,"Yes","No")
Maybe with this formula as shown in the attached file.