Comparing Dates to see if they are in the same month and then adding them

[BoggleJ]

So for my work I am trying to make an Excel spreadsheet for my sales job. We get paid based on the number of closings in the month from previous sales, and our pay tier is based on the number of sales in the same month we get of closings. So I am trying to compare the date that we first spoke with a client to when we got the sale and add each one that matches in 1 formula. This formula is as close as I got and it only returns the 1 value =IF(AND(YEAR(B7:B25000)=YEAR(P7:P25000),MONTH(B7:B25000)=MONTH(P7:P25000)),1,0). I have tried adding SUM to it to see if that works and I feel like I am either doing it wrong i tried this =IF(SUM(AND(YEAR(B7:B25000)=YEAR(P7:P25000),MONTH(B7:B25000)=MONTH(P7:P25000)),1,0)). Can someone help me out with this?

 

[BoggleJ]

Here is what it looks like with the applied formulas and where I am having a problem I am clearly missing something

 

[BoggleJ]

I think this might be what your after?

=COUNTIFS(B:B,">="&AD6,P:P,"<"&AD7)

After some tinkering I figured out how to use this function to resolve what I was looking for thank you

 

[EFANYoutube]

With the formula I gave you, it works on the current date and the date below, so..
Count number of times there is an occorance where anything in B is bigger than AD6 and the same row returning a true has a date less than AD7