Count # of Occurrences for specific Reason within 90 Days

[Victor G]

I am trying to figure out how to make excel count the total # of write-ups an employee has for a specific write-up from the drop down within 90 days. I can't figure out how to make this happen.

It's pretty hard to explain but I'm sure it's something very easy. I've included an attachment of my File so u can see what I'm talking about. Any help would be appreciated/

[MarvinP]

Hi Victor and welcome to the forum,

See if this formula works for you:

=COUNTIFS(A:A,">" & TODAY()-90,B:B,D2)

in the attached.

[Victor G]

Hmm, cant seem to get it to work.

Basically what I need help with is to get E to count the amount of dates within 90 days of all of A with the criteria reason selected in B drop downs.

So if 04/21/2015 was entered in A4 and Conflict of Interest was selected from the drop down on B4 then it updates it as a SUM on E11.

Hopefully that gives a better idea with what I need help with lol. I'm really bad at explaining things :-/ Sorry

[FlameRetired]

Hmm, cant seem to get it to work.

Basically what I need help with is to get E to count the amount of dates within 90 days of all of A with the criteria reason selected in B drop downs.

So if 04/21/2015 was entered in A4 and Conflict of Interest was selected from the drop down on B4 then it updates it as a SUM on E11.

Try changing D2 in MarvinP's formula to D4. It works at my end.