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
Hi,
Instead of COUNTA can you not use a
HTH=COUNTIF(your_range,">"&0)
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star iconat the bottom left of my post.
Nope, it doesn't work. but thanks anyway, i'll just have to find an alternative.
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
Richard Buttrey
If this was useful then please rate it appropriately.
Click the small star icon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks