Countif, Count, Offset, Counta and Charts

[riyo91]

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

[Richard Buttrey]

Hi,

Instead of COUNTA can you not use a

Please Login or Register  to view this content.

HTH

[riyo91]

Nope, it doesn't work. but thanks anyway, i'll just have to find an alternative.

[Richard Buttrey]

Hi,

I'm not quite sure why you say this won't work. As I understood the original problem your COUNTA was not ignoring a blank result in a cell since the cell itself contained a formula which is regarded by the COUNTA as being a 'value'. The COUNTIF() should return the count of all non blank cells and if I understand your problem will return a value one less than the COUNTA formula (assuming one blank result in the range looked at).

Substituting the COUNTIF() for your COUNTA() should return a different result.

Rgds