![]() |
|
#1
|
|||
|
|||
|
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? |
|
|
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 |