Count if But the is the last two letters=CD

[tonywatsonhelp]

Hi Everyone,

I have a sheet call "Extended" which has lots of sales in it
column O is the region

however its not showing as i need
for eg it might say "Hello CD" or "Howard CD" or "TimeCD" or something complete different! but always ends with "CD" (if it doesn't i dont want to count them)
so what i need is this,
A macro that can Countif the last two Letters in each cell are "CD"

So for example

Column O
Hell CD	count
PlaceHQ
BIG House
TonyCD	count
hands of CD	count
Wow CD	count
Nothing
Me
Help		So the count is 4

 

[Joe4]

A macro is not necessary.

You can do it like this:

=COUNTIF(A2:A10,"*" & "CD")

If you need to do it in VBA, you can use "Application.WorksheetFunction.Countif..." to use most Excel functions in VBA.

 

[tonywatsonhelp]

thank you joe, worked great