offset function Dunamic Chart

[nicci1944]

I wonder if anybody can direct me to this annoyingly issue. I'm trying to use OFfset function to make my chart dynamic. I can work the calculation proper with only issue my calc doesn't like if the value it contains is a text. It works fine if its a number Any help is appreciated. I can't post spreadsheet but the below is what I'm trying to achieve, so for every new row I should get the value

OFFSET($a$28,COUNT($a$27:$a$32),,1,)

Application name
[TABLE="width: 162"]
<tbody>[TR]
[TD]fd[/TD]
[/TR]
[TR]
[TD]er[/TD]
[/TR]
[TR]
[TD]Why[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[/TR]
[TR]
[TD]Nicci[/TD]
[/TR]
[TR]
[TD]Niccikaren[/TD]
[/TR]
[TR]
[TD]ddd[/TD]
[/TR]
[TR]
[TD]fg[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[TABLE="width: 162"]
<tbody>[TR]
[TD]fd[/TD]
[/TR]
[TR]
[TD]er[/TD]
[/TR]
[TR]
[TD]Why[/TD]
[/TR]
[TR]
[TD]Name[/TD]
[/TR]
[TR]
[TD]Nicci[/TD]
[/TR]
[TR]
[TD]Niccikaren[/TD]
[/TR]
[TR]
[TD]ddd[/TD]
[/TR]
[TR]
[TD]fg[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[kalikj]

Very simple; use COUNTA instead of COUNT.

 

[nicci1944]

Very simple; use COUNTA instead of COUNT.

I'm positive I tried this a well

 

[kalikj]

it works when I have tried it on your data