I'm clearly a newb. Here's a simple example of where I'm stuck. I tried searching, but most examples of this are complex and difficult to trace.
Cell A1 = ABCDEF
Cell A2 = ABCFED
Cell A3 = FEDCBA
Cell A4 = SUMPRODUCT(LEFT(A1:A3,3)="ABC")
Returns zero, not 2? What am I missing?
Thank you kindly for your help.
Hi,
a small change
=SUMPRODUCT(--(LEFT(A1:A3,3)="ABC"))
or
=COUNTIF(A1:A3,"ABC*")
Hope it helps
Last edited by canapone; 10-11-2014 at 01:42 PM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Try this: SUMPRODUCT(N(LEFT(A1:A3,3)="ABC"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks