Countif or Sumproduct question

[buyshirts]

I have tired several ways to perform what (i think) should be easy.

In Column A i have text that starts in the same manor but after 19 characters there is some info i want to use.
Below is a sample the text in Bold is what i need to use

A1 Greyhound Racing / CPark 25th Sep : D4 265m
A2 Greyhound Racing / Swin 25th Sep : A4 476m

I have used the MID function to extract this and then on a different sheet im trying to Count how many times CPark in the data set and then im also trying to sum another column if CPark is present.

So this is all pretty standard stuff but for some reason im getting 0 as the answer to the count formula.

Any helped would be much appreciated

 

[steve the fish]

The countifs could be:

=COUNTIFS(A:A,"*CPark*")

The sumifs is the same but has a sum range added.

=SUMIFS(B:B,A:A,"*CPark*")

 

[buyshirts]

Thanks very much for your help!

 

[buyshirts]

Sorry as an additional point do i have re-write the formula with the actual name can i not use a cell reference instead ?

 

[steve the fish]

Yes you can use for example:

"*"&C1&"*"

where C1 houses the criteria you want to count.

 

[buyshirts]

Thanks once again it would of taken my a lifetime to work that out!