Monday, January 27, 2014

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...
---
-------------------------------------------------------------------------------------------------------------------------