Forum Discussion
COUNTIF using INDIRECT references
Hello, I am using the COUNTIF function in one Excel workbook (Workbook A) to count the number of times certain account names appear within specific ranges of another Excel workbook's (Workbook B'...
1) You don't need TEXTJOIN. For such model
formula could be
=SUM( COUNTIF( INDIRECT( Table1[Range addresses] ), [@[Values to count]] ) )COUNTIF returns array of counts for each range which we sum to receive total counts.
2) Please note, INDIRECT doesn't work if referenced file is closed, you shall keep General Ledger opened.