How do I count the number of cells in a column in excel that begi.

S

Sherd

I have a column containing entries of the type E0007 and others of the type
VE0007, how doI use a countif formula to just count the ones beginning with
VE?
 
B

Bob Phillips

=COUNTIF(A:A,"VE*")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top