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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Back
Top