yogi_count Instances By Matching DEPARTMENT And MONTH And YEAR In Another Sheet

                                         Google Spreadsheet   Post  #1499
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-27-2014
post by Nick Depratto (http://productforums.google.com/forum/#!mydiscussions/docs/L02CQBQoi2Y)
Countifs with multiple date and name ranges

Hello, 

I have a sheet that i would like to pull data from but with names and dates. I would like to know how to count when one row with a certain name has been entered into the sheet in a certain date range. 

thanks in advance...

---

Here is a link to a editable sheet. 

https://docs.google.com/spreadsheet/ccc?key=0Am7X0hxg0iyBdEZwNXpoRm1RSlNmNzl1Y09uWFdmWlE&usp=sharing

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