INDIRECT formula giving #VALUE error when adding COLUMN() and not sure how to fix..

**Cullen8** · 01-26-2012, 01:25 PM

Hi All,

Hoping someone can help with my ignorance. I've got a sumproduct formula that's giving me issues.

Currently the formula is:

Please Login or Register  to view this content.

I'd like to update to:

Please Login or Register  to view this content.

But, this gives me the #VALUE error and not sure how to fix.

Any help is greatly appreciated.

Thanks,
Cullen

**Special-K** · 01-26-2012, 01:32 PM

Posting a file would help since this is data dependant

**bebo021999** · 01-26-2012, 01:33 PM

Try to replace COLUMN(C1) with COLUMNS(A1:C1)

**Cullen8** · 01-26-2012, 02:37 PM

Thanks bebo021999,

That did it!

Thanks,
cullen

Re: INDIRECT formula giving #VALUE error when adding COLUMN() and not sure how to fix