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

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?

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

--

HTH

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


"Sherd" wrote in message
...
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?