Hi all
I have a column containing delivery numbers
I would like to count the occurrences of 10 digit delivery numbers which start with 4500 and 4400
Example attached
Hi all
I have a column containing delivery numbers
I would like to count the occurrences of 10 digit delivery numbers which start with 4500 and 4400
Example attached
For instance:
Formula:=SUMPRODUCT(--(LEFT(A:A,4)="4500"))
Best Regards,
Kaper
Sorry for the delayed response, many thanks that works fine.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks