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

08-06-2019, 03:09 AM

Debaser

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

Without helper column:

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

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