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"),"correct response"))
and enter the formula with CTRL+Shift+Enter.
Regards
Claus B.
--
Windows10
Microsoft 365 for business
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)