Excel formula query

[CLARE83]

Hi, I'm wanting a formula that will count a cell if it contains 1 and or 1a, 1b, 1c etc. I currently use "1?" but this only counts the cells with 1a,1b,1c in any ideas how I can get it to count the 1 cells aswell?

Hope it makes sense.

Thanks in advance

Clare

 

[admiral100]

Hi

Try this Ctrl+Shift+Enter NOT just Enter

=COUNT(FIND("1",D14:D18&""))

 

[CLARE83]

Thanks for that although I couldn't get it to work, I have copied an example below in which I want to count how many "1" or "1a" "1b" or "1c" appear in row S - i currently use COUNTIF(marksheet name!S$2:$S251,"1?") but that only counts the cells with a a,b,or c at the end not the whole number cells, hope i'm making sense.
[TABLE="width: 700"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[TD]Q[/TD]
[TD]R[/TD]
[TD]S[/TD]
[/TR]
[TR]
[TD]name 1[/TD]
[TD]F[/TD]
[TD]9KN[/TD]
[TD]9A5/En 17/18[/TD]
[TD]BOSCOBEL[/TD]
[TD]K[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Y[/TD]
[TD]92[/TD]
[TD]L[/TD]
[TD]3[/TD]
[TD]8.85[/TD]
[TD]2.8[/TD]
[TD] [/TD]
[TD]1A[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]name 2[/TD]
[TD]M[/TD]
[TD]9AP[/TD]
[TD]9A3/En 17/18[/TD]
[TD]ATTINGHAM[/TD]
[TD]N[/TD]
[TD]Y[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]96[/TD]
[TD]L[/TD]
[TD]4[/TD]
[TD]14.2[/TD]
[TD]4.7[/TD]
[TD] [/TD]
[TD]3A[/TD]
[TD]3[/TD]
[TD]2C[/TD]
[/TR]
[TR]
[TD]name 3[/TD]
[TD]M[/TD]
[TD]9FR[/TD]
[TD]9A3/En 17/18[/TD]
[TD]ATTINGHAM[/TD]
[TD]N[/TD]
[TD] [/TD]
[TD]Y[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]96[/TD]
[TD]M[/TD]
[TD]5[/TD]
[TD]16.9[/TD]
[TD]5.6[/TD]
[TD] [/TD]
[TD]4A[/TD]
[TD]4[/TD]
[TD]2C[/TD]
[/TR]
[TR]
[TD]name 4[/TD]
[TD]F[/TD]
[TD]9FR[/TD]
[TD]9B4/En 17/18[/TD]
[TD]ATTINGHAM[/TD]
[TD]N[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Y[/TD]
[TD]Y[/TD]
[TD]100[/TD]
[TD]L[/TD]
[TD]4[/TD]
[TD]14.6[/TD]
[TD]4.9[/TD]
[TD] [/TD]
[TD]3A[/TD]
[TD]3[/TD]
[TD]1B[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col span="4"><col><col><col><col><col><col><col><col><col></colgroup>[/TABLE]

 

[admiral100]

Ctrl+Shift+Enter
=COUNT(FIND("1",'marksheet name'!S2:S5))

It's work for me...