Sumproduct #Value! Error due to Text

Originally Posted by Carim

Hi,

In order to get the exact row number, given the fact you are storing your different years from C6 or row 6 ... the five first rows are missing in the total to get the exact row number ...

Oh I see,
That's the empty rows between the reference cell C2 and the first row of the data line ie. year 2002.

Got it.

Thanks for shining the light.
Ricky