Hi All,

I have this formula to count number of incidents within a specified month:

=COUNTIFS(A:A,">=1/1/2012",A:A,"<=1/31/2012")

-----------------------------------------------------

Now, on the following column, I'm trying to find a formula that counts the number of incidents resolved (YES) within that same month.

I've tried using the same formula with the additional argument (I:I,"YES") but it did not work.

Can somebody please help me out?

COUNTIFS, SUMPRODUCTS, DCOUNT..........I could not get any of those to work

I've been trying to figure it out the past few hours, and it's driving me insane

Any help is greatly appreciated. Thank you in advance!