Thread: How do I ask a cell to look only at the first character in a cell
View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default How do I ask a cell to look only at the first character in a c
"Toppers" wrote...
=SUMPRODUCT(--(LEFT(C2:C50)="A"))

=SUMPRODUCT(--(LEFT(C2:C50)="H"))

=SUMPRODUCT(--(LEFT(C2:C50)="V"))
....

Urgh!

=COUNTIF(C2:C50,"A*")

=COUNTIF(C2:C50,"H*")

=COUNTIF(C2:C50,"V*")


Reply With QuoteReply With Quote