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

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

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




"soconfused" wrote:

I posed the question wrong. What I really want is a sum of a column with the
first letter of every cell being the variable.

Thanks
--
DMM


"soconfused" wrote:

I am trying to look at a cell and put a #1 in it:

Example Column C = A-LA41-09-92256 I need a formula here
to put a # 1 if the value is A- or H-

Thanks in advance.

DMM
Reply With QuoteReply With Quote