Thread: Excel Function To Count All Strings In Range
View Single Post
 
Old 09-21-2020, 06:22 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
You can just use countifs


=COUNTIFS(A1:A6,E1)


Please attached a workbook instead of a picture so we dont have to waste time recreating the data


Copy the whole list, paste & remove duplicates, then countifs
Reply With Quote