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 Sheet61 with the total appearing in separate summary sheet. If COUNTIF can't be used, what formula syntax would give me the solution?
Bookmarks