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

mgroessl · 08-06-2019, 03:39 PM

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!!