LinkBack URL
About LinkBacks
This should work for you. It will count the number of occurrences of "AST" in the range A1:A26. This assumes "AST" is the three leftmost characters in a given cell. Change your range as necessary.
=SUMPRODUCT(--(LEFT(A1:A26,3)="AST"))
This should work for you. It will count the number of occurrences of "AST" in the range A1:A26. This assumes "AST" is the three leftmost characters in a given cell. Change your range as necessary.
=SUMPRODUCT(--(LEFT(A1:A26,3)="AST"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks