help with multiple criteria selections

I have been working on a worksheet that we will use to inspect our construction sites. My question is if i enter a list like shown below is there a way a) of having a cell count the number of "CB" that also have "m" in column d and have the row transferred to a second worksheet

Example:

a b c d e
1 lot # waste structure condition notes
2 113 G CB G
3 120 G CB M NEEDS CLEANING
4 133 G SI M FIX
5 112 G SI G
6 111 G CB,SI M FIX INLET

I would like for it to count anytime cb is referrenced in column "c" even where it is used as cb,si and then count the "m" in d that coresponds.

as you can tell i am just beginning with more complex excel sheets so any help would be appreciated

if cb is always the start of the cell perhaps
sumproduct((left(c2:c10,2)="CB")*(d2:d10="M"))

or

sumproduct((left(c2:c10,2)="CB")*(left(d2:d10,1)="M"))

Regards

Dav

thanks for the help