I am trying to use the countif function across multiple sheets.
So the range will included specific cells on each sheet, approximately 30 sheets. So each cell on each sheet will have a yes or no in it, and I want the function to count how many yes's and how many no's, for example.
I have tried this equation however it comes back with an error. I am not looking at a range on each sheet just specific cells, so the range would not be A1:A12, it would just be A1 on every sheet. Is that why the equation is not working. The range is the same cell across 30 sheets?
Example spread sheet attached. All I want to do is count how many yes's and how many no's across a number of sheets. So the summary sheet shows the number of yes's and number of no's.