Is there a way to create a countif formula across multiple sheets? Hypothetically, I want to count each "B" in cell N6 for Sheet 1 through Sheet 50. Can this be written as a CountIF formula?

Thanks for any help!