Count cells within a specific date range that contain a specific word

I have a spreadsheet which I have attached. The "Dashboard" sheet contains a breakdown of failures, month to month. I have created the formula in E2 that will count all the cells in "Failures" column D, that contain a date that is within a specific range. In this case the range is 7/1/2013 to 7/31/2013. Now what I am trying to do is count how many within that range contain certain failure modes which are listed in Column D of "Dashboard"

In cell E3 of "Dashboard" I need a formula that will count the number of times that "NFF" appears in column K of "Failures" within the date range of 7/1/2013 to 7/31/2013.


Any help would be great.

Try this in cell E3 and copy to the right.

=COUNTIFS(Failures!$D:$D,">="&E$1,Failures!$D:$D,"<="&EOMONTH(E$1,0),Failures!$K:$K,$D3)

Is that what you mean?

Note the $D3 at the end of the formula is referencing the cell D3 that contains "NFF". You could easily hard code the text into the formula if you prefer.

BSB.

And your formula in E2 could be =COUNTIFS(Failures!$D:$D,">="&Dashboard!E$1,Failures!$D:$D,"<="&EOMONTH(E$1,0))
Again, copied right to cover all months.

With a helper column.

All of these solutions worked perfectly.

Thanks everyone!