I’m running into an issue with a document I need to maintain that I inherited. There is a table on the main page, in the A column there are date’s listed as Dec-10, Dec-11, etc., etc. Each one of those dates has a corresponding sheet with the same name. In those sheets in the C column is a list of names for that day.
In the I column is a list of all unique names. In the G column, there is a formula that doesn’t work and I cannot figure out why. The formula is
COUNTIF(INDIRECT($A$2:$A$257&"::Table 1::$C"),$I2)
It should return around 237 but instead returns 0. If I only target one cell in the A column, the formula works fine. The INDIRECT description in the formula help tray does say you can use a range as a reference.
I’m hoping someone can shed some light on what I need to adjust to get this to work properly
