Microsoft Office Forums - View Single Post - [Solved] Trying to count the number of cells ending with 001 or 002

Thread: [Solved] Trying to count the number of cells ending with 001 or 002

View Single Post

Old

08-06-2019, 03:09 AM

Debaser

Debaser is offline

Debaser uses Windows 7 64bit

Windows 7 64bit Debaser uses Office 2010 32bit

Debaser uses Office 2010 32bit

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