Thanks, that worked to a certain extent but I do have some cells that meet
that criteria (begin with €œPO€�) but are still invalid as they do not contain
the correct number of characters or begin with €œPO€� and are 20 characters in
length but do not meet a standard format (PO-7611189-0710/M895 vs.
PO-31245184/M8768901). The standard that I require to be met is
€œPO-########/M#######€� and any variances, including being case sanative, be
counted.

"Gary''s Student" wrote:

To count the number of values in column D that begin with PO:
=SUMPRODUCT((LEFT(D1:D100,2)="PO")*(D1:D100<""))

--
Gary''s Student - gsnu200812