I am running into a small problem getting a COUNTIFS formula to work. I need the formula to look at a different tab that contains the data. I need to count two different pieces of cirteria shown below.
Criteria 1 - project name
Criteria 2 - count # of cells (by date range) that relate to the project by month/year
If I count the blank cells (for the date range) it works fine. What I cannot get to work is getting the date range piece.
here is my current formula (to count blank date ranges)
=COUNTIFS(Projects2009toCurrent!L:L,"*Project 2.0*",Projects2009toCurrent!Q:Q,"")
I know at the end of the formula where the "" is, I need to include a date range. The date range I am trying to use is 10/1/2013 to 10/31/2013.
Any help is appreciated.
Glen
Bookmarks