Ok thanks for All the replies 3 different ways ;-) i shall try those tomorrow
n let you all now how it all went. Cheers xx

"coltheplumb" wrote:

Ok i have a set of letters in each cell in a row ie,

A B C D etc to J %
be cw de dw etc to J 50

now i have the formular in place to show me in % terms how many cells have
been filled over the range ie, if 5 out of the ten cells have been filled it
shows a % of 50.
What i am trying to do is if i fill a cell with a number instead of a letter
i dont want the number to be counted as a filled cell ie

A B C D etc to J %

be 1/2 de dw etc to J 40

i know there must be a way but try as i might i cant find it DOH! all help
much appriciated
Thanks Colin xx