Forum Discussion
Referencing Sheet Names in a Dynamic Table
I'd like some help resolving a reference error in a formula designed to use Sumif across multiple sheets. Here's the problem statement: a) I'm developing Workbook for managing vendors and con...
Is there an easy way to fix it? The INDIRECT is set up the same in both examples, so I'm assuming there is an adjustment made necessary because one is a table column and the other is a static list, but I'm stuck as to what that would be.
Not familiar with your setup, but what if you remove this bit: &"!C3"