Counting Cells Containing Part of a Text, that matches critera in another column

Hi
Iam trying to find a formula that will search the beginning part of a cell, for a certain piece of text, and then counting the result if criteria in another column is true.

I have used the sumproduct formula before, but this only works if the cells specifically contain the text that is searched for.

=SUMPRODUCT(($B$2:$B$72="N/R")*($C$2:$C$72=1))

the data that I have has the "N/R" at the beginning of each cell eg Cell B8 = N/R BLACK DRAWING PAD or some of the text looks like this eg Cell B12 = (N/R)POSTER PAINT NEON

so what I want the formula to do, is search column B for any cells that have N/R or (N/R) at the beginning. then count if it matches certain data in column C

any help will be much appreciated

Use LEFT:

=SUMPRODUCT((LEFT($B$2:$B$72,2)="N/R")*($C$2:$C$72=1))

or Search

=SUMPRODUCT((ISNUMBER(SEARCH("N/R",$B$2:$B$72)))*($C$2:$C$72=1))