How do I ask a cell to look only at the first character in a c
"Peo Sjoblom" wrote...
....
otherwise try
=SUMPRODUCT(--(LEFT(C2:C50)={"A","H","V"}))
....
Or try
=SUM(COUNTIF(C2:C50,{"A","H","V"}&"*"))
or a slightly shorter array formula in which it's easier to change the
letters sought,
=COUNT(FIND(LEFT(A1:A30,1),"AHV"))
|