Use countif across multiple tabs for a column

		Microsoft Office Forums > Microsoft Excel > Excel
Use countif across multiple tabs for a column

FAQ

Thread Tools

Display Modes

marconexcel Use countif across multiple... 02-15-2017, 09:08 PM

xor No. COUNTIF cannot handle 3D... 02-15-2017, 10:38 PM

marconexcel Countif question 02-18-2017, 11:32 AM

jeffreybrown See how this works for you...... 02-16-2017, 05:40 AM

marconexcel Thanks for your reply. I've... 02-20-2017, 08:53 PM

Pecoflyer Why not : group the tabs... 02-21-2017, 12:24 AM

jeffreybrown See if this example helps...... 02-21-2017, 05:38 AM

02-16-2017, 05:40 AM

jeffreybrown jeffreybrown is offline

Windows Vista Use countif across multiple tabs for a column

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

See how this works for you...

=SUMPRODUCT(COUNTIF(INDIRECT("'"&MySheets&"'!B:B") ,"Item"))

List all your tab names and create a named range called MySheets

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF(INDIRECT doesn't autoupdate cell references when I add a column somewhere else in my sheet	Helix2	Excel	7	10-25-2016 03:20 AM
Multiple browser windows or tabs	Buckeyegator	Outlook	1	11-28-2011 08:53 PM
Multiple browser windows or tabs	Buckeyegator	Office	0	11-27-2011 05:06 PM
Multiple IExplorer Tabs open with link	robertkjr3d	Outlook	2	07-26-2010 11:30 AM
Create Multiple Tabs from Template	TeePee	Excel	0	04-30-2009 11:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:51 PM.