# QTY count of letter in A1:A4

#### caabyyc

##### Board Regular
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>

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### StephenCrump

##### Well-known Member
=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".

Last edited:

##### MrExcel MVP
Try...

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

Note. SUBSTITUTE is case-sensitive.

#### caabyyc

##### Board Regular
Thanks all, the "F" formula works well .

##### MrExcel MVP
=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.

Replies
4
Views
87
Replies
3
Views
110
Replies
22
Views
383
Replies
3
Views
273
Replies
10
Views
184