Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 08-06-2019, 03:09 AM
Debaser's Avatar
Debaser Debaser is offline Trying to count the number of cells ending with 001 or 002 Windows 7 64bit Trying to count the number of cells ending with 001 or 002 Office 2010 32bit
Competent Performer
 
Join Date: Oct 2015
Location: UK
Posts: 221
Debaser will become famous soon enough
Default

Without helper column:

=SUMPRODUCT(--(RIGHT($R$2:$R$5000,3)={"001","002"}))
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to count the number of cells ending with 001 or 002 Count the Number of Cells Containling Dates skeezix Excel 13 05-25-2019 06:11 AM
Trying to count the number of cells ending with 001 or 002 How to Auto Number When document opening is in Column 2 and ending is in Column1 anilsharaf Word 3 09-07-2017 06:27 PM
Trying to count the number of cells ending with 001 or 002 count the number of text in a cell based off a different cells text Kubi Excel 4 08-24-2017 05:53 PM
Trying to count the number of cells ending with 001 or 002 count a number of cells based on the beginning of a order number Kubi Excel 2 08-06-2017 08:54 PM
Count range cells eliminating merge cells danbenedek Excel 0 06-15-2010 12:40 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:53 AM.


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