Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 02-15-2017, 09:08 PM
marconexcel marconexcel is offline Use countif across multiple tabs for a column Windows 7 64bit Use countif across multiple tabs for a column Office 2013
Novice
Use countif across multiple tabs for a column
 
Join Date: Feb 2017
Posts: 6
marconexcel is on a distinguished road
Default Use countif across multiple tabs for a column

I would like to use countif across multiple month tabs for an entire column. I can use the following format for sum and it works: =sum(jan:dec!b:b)
I can use countif for one tab and a whole column: =countif(Jan!b:b,"item")


When I use countif across multiple tabs I get a #value! error message: =countif(jan:dec!b:b,"item")
Is there a way to use countif the way I am trying to use it?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Use countif across multiple tabs for a column 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
Use countif across multiple tabs for a column 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 08:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft