QTY count of letter in A1:A4

[caabyyc]

Hi, could you please help?
Source: A1:A4,
want to: count total QTY of letter "F"(upper case only) in A1:A4 (formula only please)
correct result should be 4.

	A
1	F4545
2	39FF
3	345F
4	5923f

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[StephenCrump]

=sumproduct(len(a1:a4)-len(substitute(a1:a4,"f","")))

Edit: For some bizarre reason, this keeps losing its capitalisation. Use Aladin's version with capital "F".

 

[Aladin Akyurek]

Try...

=SUMPRODUCT(LEN(A1:A4)-LEN(SUBSTITUTE(A1:A4,"F","")))

Note. SUBSTITUTE is case-sensitive.

 

[caabyyc]

Thanks all, the "F" formula works well .

 

[Aladin Akyurek]

=sumproduct(len(a1:a4)-len(substitute(a1:a4,"f","")))

Edit: For some bizarre reason, this keeps losing its capitalisation. Use Aladin's version with capital "F".

The board software sets a formula in lower case if nothing else in addition is typed.