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

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 »

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:49 AM.