Hi all again
maybe you can help with this
i need a formular to count only filled cells with p p1 p2 up to p10 ie,

A B C D etc to J %
p p1 p2 p3 etc to p10 40% (assume E to J are empty cells)
but i need to enter other letters/numbers that i dont want counted as filled
cells ie,

A B C D etc to J %
p a r p3 etc to J 20% (assume E to J are empty
cells)

I do have this set up but i have done it long hand with a long string of
formulars that cover each p .

again thanks for your help
Colin xx

Try

=COUNTIF(A1:J1,"p*")*10%

and format to %

If this post helps click Yes
---------------
Jacob Skaria


"coltheplumb" wrote:

Hi all again
maybe you can help with this
i need a formular to count only filled cells with p p1 p2 up to p10 ie,

A B C D etc to J %
p p1 p2 p3 etc to p10 40% (assume E to J are empty cells)
but i need to enter other letters/numbers that i dont want counted as filled
cells ie,

A B C D etc to J %
p a r p3 etc to J 20% (assume E to J are empty
cells)

I do have this set up but i have done it long hand with a long string of
formulars that cover each p .

again thanks for your help
Colin xx

Thank You Jacob ;-) Works brilliantly xx

"Jacob Skaria" wrote:

Try

=COUNTIF(A1:J1,"p*")*10%

and format to %

If this post helps click Yes
---------------
Jacob Skaria


"coltheplumb" wrote:

Hi all again
maybe you can help with this
i need a formular to count only filled cells with p p1 p2 up to p10 ie,

A B C D etc to J %
p p1 p2 p3 etc to p10 40% (assume E to J are empty cells)
but i need to enter other letters/numbers that i dont want counted as filled
cells ie,

A B C D etc to J %
p a r p3 etc to J 20% (assume E to J are empty
cells)

I do have this set up but i have done it long hand with a long string of
formulars that cover each p .

again thanks for your help
Colin xx