Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 11th 21, 06:51 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2021
Posts: 2
Default COUNTIF across multiple tabs in Google Sheets

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.

  #2   Report Post  
Old February 11th 21, 07:02 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,866
Default COUNTIF across multiple tabs in Google Sheets

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
  #3   Report Post  
Old February 11th 21, 08:07 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2021
Posts: 2
Default COUNTIF across multiple tabs in Google Sheets

Hi,

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do the tabs disappear (workbook has multiple sheets) Mel Excel Discussion (Misc queries) 1 January 20th 10 07:56 PM
COUNTIF for multiple sheets Keyrookie Excel Worksheet Functions 3 January 20th 09 10:43 PM
SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter Greg in CO[_2_] Excel Worksheet Functions 0 September 18th 08 05:51 PM
COUNTIF across multiple sheets Gizmo63 Excel Worksheet Functions 3 April 10th 06 11:42 AM
Deleting multiple Chart Tabs/sheets CLR Excel Programming 13 March 6th 05 03:58 AM


All times are GMT +1. The time now is 09:36 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017