I’m banging my head against the wall on this formula. It is the last one I need to complete my spreadsheet.

I have a date column and another column with the letters “BPA, BPE, BP, BPV” in them. I am trying to right a formula that will total the number of instances of any “BP*” in the column and total by each month. January, February, etc.

Here is what I have tried but it is not working.
=SUM(IF($B$2:$B$1000>=DATEVALUE(”01/01/2010″),IF($B$2:$B$1000<=DATEVALUE("01/31/2010"),IF($M$2:$M$1000="BP",IF($M$2:$M$1000="BPA",IF($M$2:$M$1000="BPB",IF($M$2:$M$1000="BPE",IF($M$2:$M$1000="BPV",1,0),0),0),0),0),0),0))

The result is coming back zero.
Am I even close?!

thanx in advance, Todd