Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Excel Function To Count All Strings In Range
Register FAQ Mark Forums Read

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 09-21-2020, 06:22 PM
Purfleet Purfleet is offline Excel Function To Count All Strings In Range Windows 10 Excel Function To Count All Strings In Range 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
 

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Threaded Mode Threaded Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel VBA function range.replace thomas47 Excel Programming 7 03-25-2019 08:25 AM
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug) slaycock Word VBA 0 02-18-2017 07:00 AM
Function to Count Data bdavidson22 Excel 0 12-19-2014 11:48 AM
Excel Function To Count All Strings In Range Count how many have completed each Training Course within a Date Range dmcmillion Excel 3 10-20-2014 09:59 AM
Use of MIN and count function together khokababu Excel 0 02-22-2012 09:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:44 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft