One way: =SUMPRODUCT(--(LEFT(C1:C3)="4"))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---
"gemsey" wrote:
I'm having problems with finding the right formula. I've been using a
countif to find the count of invoices which start with a 4. I've not been
having much luck so any help would be greatly appreicated.

Below is my sample data and formula I've been using:

=COUNTIF(C1:C3,"4*")

Row C
5017846
6007051
4000124