How do I ask a cell to look only at the first character in a c
On Wed, 15 Aug 2007 12:08:05 -0700, soconfused
wrote:
I didn't pose the question right. I should have said I have a column with
these variables and at the bottom, I want to sum all the A's, H's and V's.
E1: A
E2: H
E3: V
F1: =COUNTIF(C:C,E1&"*")
Select F1:F3 and Fill Down (<ctrl-D)
--ron
|