Or eventually =SUMPRODUCT(--(LEFT(A1:A100,1)="W"))
which does not need entering with CSE

( if you use Office 2000 entire ranges will not work for sumproduct)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post