another formular help please

[coltheplumb]

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

 

[Jacob Skaria]

Try

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

and format to %

If this post helps click Yes

 

[coltheplumb]

Thank You Jacob ;-) Works brilliantly xx

Try

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

and format to %

If this post helps click Yes