1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • COUNTIF across multiple tabs in Google Sheets

    From Claus Busch@21:1/5 to All on Thu Feb 11 20:02:50 2021
    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)
  • From Victoria Emory@21:1/5 to All on Thu Feb 11 10:51:29 2021
    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.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Victoria Emory@21:1/5 to All on Thu Feb 11 12:07:54 2021
    Hi,

    Thank you for trying, but it is "counting" and showing 0 when I know there are more than 0 data entries.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)