Hi all-
I've been searching through the forum and couldn't quite pinpoint my exact scenario.
I am aware xxxIF formulas don't work on referencing closed workbooks so I've been trying to utilize alternative methods.
I'm trying to find how many instances of a particular cell are found in a specific column range. For instance, this formula works:
But when trying to add additional IF statements/workbooks, I'm not getting accurate results:
The cell B11 is a text phrase (in this example it is Customer Inquiries).
Any idea what I'm doing wrong? I have about 12 closed workbooks to stick into this formula. All are identical. The current output of that 2nd formula is 1. It should be 3.
Thanks,
brat
I've been searching through the forum and couldn't quite pinpoint my exact scenario.
I am aware xxxIF formulas don't work on referencing closed workbooks so I've been trying to utilize alternative methods.
I'm trying to find how many instances of a particular cell are found in a specific column range. For instance, this formula works:
Excel Formula:
=COUNT(IF('[filename.xlsx]Tab'!$C$5:$C$1000=B11,1))
But when trying to add additional IF statements/workbooks, I'm not getting accurate results:
Excel Formula:
=COUNT(IF('[filename.xlsx]Tab'!$C$5:$C$1000=B11, IF('[differentworkbook.xlsx]Tab'!$C$5:$C$1000=B11,1)))
The cell B11 is a text phrase (in this example it is Customer Inquiries).
Any idea what I'm doing wrong? I have about 12 closed workbooks to stick into this formula. All are identical. The current output of that 2nd formula is 1. It should be 3.
Thanks,
brat