Trying to count the number of cells ending with 001 or 002

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Trying to count the number of cells ending with 001 or 002

FAQ

Mark Forums Read

Thread Tools

Display Modes

08-06-2019, 03:39 PM

mgroessl

Windows 10 Trying to count the number of cells ending with 001 or 002

Office 2016

Novice

Join Date: Jul 2019

Posts: 4

Perfect

Quote:

Originally Posted by Debaser

Without helper column:

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

Debaser, Thanks!! This works perfectly, without having to rely on the Helper column. That one worked, but this does seem to be more efficient!!

Thanks Again!!

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Count the Number of Cells Containling Dates	skeezix	Excel	13	05-25-2019 06:11 AM
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
count the number of text in a cell based off a different cells text	Kubi	Excel	4	08-24-2017 05:53 PM
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 03:48 AM.