Is there a way to use the COUNTIF function in Excel for 3D calculation of a text entry? Specifically trying to count how many “yes” or “no” answers provided in cell A12 on Sheet1 through Sheet254 with the total appearing on Sheet 255. If COUNTIF can’t be used, what formula syntax would give me the solution?
