Thread
: [Solved]
Trying to count the number of cells ending with 001 or 002
View Single Post
08-06-2019, 03:09 AM
Debaser
Windows 7 64bit
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"}))
Debaser
View Public Profile
Find all posts by Debaser