Cant figure out COUNTIF formula for my range

[gorillawar]

I have some data that has the word "pass" or "fail" in one column, and a date in the one next to it. I am trying to use COUNTIF to count how many times a pass or fail occurred within each month.

I have tried both of the below formulas:

=COUNTIF(A1:A5,"Pass"),(MONTH(B1:B5)=F13) (F13 is just the number 1, so I can drag this formula down that has a 2 in F14 and so on)

=SUMPRODUCT((A1:A5="Pass"), (MONTH(B1:B5)=F13))

Neither of these seem to work, so I assume I am missing something. Any help is appreciated.

Thanks,

 

[Fluff]

You almost got it, try
=SUMPRODUCT((A1:A5="Pass")* (MONTH(B1:B5)=F13))

 

[Legacy 436357]

Maybe something like this?

Excel Workbook
	A	B	C	D	E
1	Condition	Date
2	Fail	2/2/2018		Start Date	1/1/2019
3	Pass	2/3/2018		End Date	1/31/2019
4	Pass	2/4/2018		Pass	2
5	Fail	2/5/2018		Fail	2
6	Pass	1/1/2019
7	Fail	1/2/2019
8	Fail	1/5/2019
9	Pass	1/8/2019
Sheet1

 

[gorillawar]

Wow..I cant believe it was just an asterisk and a space I was missing. I actually put an asterisk in there, but had no space lol. Thanks a million!

 

[Fluff]

You're welcome & thanks for the feedback.
You don't actually need the space, I simply didn't remove it from your formula.