I am trying to count all of the customer numbers in our database greater than 3000. Unfortunately, all of the cells have the word "Customer" in front of them i.e. "Customer 3001". What formula can I use to solve my dilemma?
I am trying to count all of the customer numbers in our database greater than 3000. Unfortunately, all of the cells have the word "Customer" in front of them i.e. "Customer 3001". What formula can I use to solve my dilemma?
please see the att. I used COUNTA formula. I hope its helps.
Like to say thanks ?Please use the star icon.
Customer Count.xlsx
try this, adding a column that takes the actual # from the customer field and then do a countif >3000
Hi,
Assuming that your list is in A2:A100, and that every entry within that range contains the word "Customer":
=SUMPRODUCT(--(0+TRIM(SUBSTITUTE(A2:A100,"Customer",""))>3000))
Regards
Try
=SUMPRODUCT(--((SUBSTITUTE(A1:A20,"Customer ",""))*1>3000))
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks