Hi
I have attached a sample spreadsheet which includes a list of individuals with different fields. As an example, I want to do a count of all the males who have a "New or Existing" status of "E" and who have a Join Date of "Mar-2011".
However, I want the count to change based on the date that is enetered in another cell. So if I put "Apr-2011" in one cell, the count will change by matching the table's "Join Date" with the date I put in the cell.
This is what I have so far, but the formula is not being accepted.
COUNTIFS(SampleData[***],"M",SampleData[New or Existing (N/E)],"N",TEXT(SampleData[Join Date],"MMM-YYYY"),TEXT(Q4,"MMM-YYYY"))
Any help would be greatly appreciated.
Thanks.
ltsolis
Bookmarks