Microsoft Office Forums - View Single Post - [Solved] Use countif across multiple tabs for a column

Thread: [Solved] Use countif across multiple tabs for a column

View Single Post

Old

02-16-2017, 05:40 AM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

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

Reply With Quote