this didn't work for me. do the 2 dashes in front of LEFT mean something

"Sloth" wrote:

=SUMPRODUCT(--(LEFT(A1:A100)="app"))

"mmer at steelcase" wrote:

in excel how do I count cells that begin with specific text. Ex: in a
column with 100 entries, I want to count the number of cells that have the
letters "app" from the word approved as the first three characters in the cell