Couting now of rows based on cell data ending with 33

[mrexcel1716]

Hello All,

I have 12000 records/rows in the sheet. one column (Coulmn A) contains product id's. i wanted to count now of rows whose product id is ending with 33 ( Prod id's are like 1123000033, 2354000022 etc)
some one help me in counting these rows quickly

Thanks in advance

 

[Haseeb Avarakkan]

Hello, Try

=SUMPRODUCT(--(RIGHT(A1:A100,2)="33"))

adjust the range.

 

[mrexcel1716]

Thank you so much for quick reply!
your formula is working fine as expected the result!

Thanks again