Hi,

I have this problem when using an offset in a series for my line chart, i basically want the chart to recognize only the data that is shown within the column, so i used the counta function for the height within the offset function.

But now here's the annoying part, the blank cells that are in the range have functions within: =IF('Stock-Room'!D38="","",'Stock-Room'!D38).

Now the function leaves the cells blank if theres not a value in a certain cell, and becasue of the function, the counta will not work, i have tryed a million and one different ways to overcome this, but I simply get a Message saying "That function is not valid".

Can anyone help!!!!

Thanks in advance