Hello,

I have 40 tabs that I am trying to summarize on tab 1 to view my students data all at once.
I am using
=COUNTIF(INDIRECT("'""&sheets&""'!"&"D3"),"correct response)")
but it is not working. I am trying to figure out if this is even possible with such a large number of tabs.