Unfortunatley i've tried that, it distorts the figures as it tries to
calculate the % for the whole table not just to were the data ends.

"Bob Phillips" wrote:

Why not just use

=(COUNTIF(Calc!H2:H65536,"<15"))/(COUNTIF(Calc!H2:H65536,"0"))*100

--

HTH

RP
(remove nothere from the email address if mailing direct)


"dave" wrote in message
...
I have a spreadsheet that uses the following calculation:-

'=(COUNTIF(Calc!H2:H85,"<15"))/(COUNTIF(Calc!H2:H85,"0"))*100'

The problem i have is that while H2 is constant, H85 can change depending
on
how many rows their are?
I am trying to use a terminating value such a 'end' so it knows that when
i
reach 'end' it uses the previous row reference to replace what is
currently
'H85'.
Is it possible?

Hope this makes sense.