Hi Victoria,

Am Thu, 11 Feb 2021 10:51:29 -0800 (PST) schrieb Victoria Emory:

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.

try:
=SUM(COUNTIF(INDIRECT("Sheet"&ROW(2:41)&"!D3"),"co rrect response"))
and enter the formula with CTRL+Shift+Enter.


Regards
Claus B.
--
Windows10
Microsoft 365 for business