dynamic chart values formula with dynamic starting point

Hi All

I'm trying to create a dynamic chart range using the formula below but i'm getting an error.

Essentially row 3 may contain dates (unless there's no data in row 6 in which case row 3 returns 0)


what this formula should be doing is creating the offset reference by looking for the first cell that is greater than 0 taking the column number and using the row number 6 create a R1C1 style reference that indirect will evalue into a cell, then i'm looking through row 3 and counting the number of cells whose value is greater than 0 and adding 1 (as the table starts in column 2) to create the width element of the offset.

however: I keep getting a VALUE error and can't work out why - any idea?

Please Login or Register  to view this content.

you're spot on the formula I was using was working perfectly. I have c.50 dynamic named ranges and one of the first ones I wrote actually had a function misspelt which was triggering the error rather than this one. (I think i might of had calculations turned off initially)

thank you so much for your help!