COUNTIF

[Sofa King]

How do I count cells that start with a specific number?
Example 75,77,80,82,90,94 - two that start with 7, two that start with 8...
Letters are "a*" "b*" etc. =COUNTIF(B5:B23,"*es")

 

[T. Valko]

Try this:

=SUMPRODUCT(--(LEFT(A1:A6)="7"))

 

[Sofa King]

Perfect
Thank you so very much...

Try this:

=SUMPRODUCT(--(LEFT(A1:A6)="7"))

 

[T. Valko]

You're welcome. Thanks for the feedback!