| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif across multiple sheets - sheet NAME issue?
Hi there,
I am using the following formula (see below), but wondering if the sheetnames I enter have to be in the EXACT order that there are in the spreadsheet? =SUMPRODUCT(COUNTIF(INDIRECT("'"&BA2:BA151&"'!e50" ),"x")) where BA2:BA151 is a range housing the relevant sheetnames in separate cells ... AND e50 is the cell I am referencing in every sheet. I get a #REF! error. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF for multiple sheets | Excel Worksheet Functions | |||
| SUMPRODUCT, SUMIF, COUNTIF for multiple sheets for multiple criter | Excel Worksheet Functions | |||
| COUNTIF across multiple sheets with unknown names | Excel Worksheet Functions | |||
| COUNTIF across multiple sheets | Excel Worksheet Functions | |||
| CountIF across multiple sheets in a workbook | Excel Worksheet Functions | |||
Threaded Mode
