I have 4 colums: Team, Status, Project Name, and Start date
I want to write a formula based on a drop down list of things from Team, Status, and Project Name, and I am having lots of trouble.
How can I get a count of how many things there are where start date is say, before 8/15/14, where the Team, Status, and Project Name are equal to the values in the drop down list? Let's say the drop down list is in A1 (team), A2 (Status), A3(Project name), and A4(start date)
Please help me out!
I have to do this without using filter or pivot... they want it like this :/
I want to write a formula based on a drop down list of things from Team, Status, and Project Name, and I am having lots of trouble.
How can I get a count of how many things there are where start date is say, before 8/15/14, where the Team, Status, and Project Name are equal to the values in the drop down list? Let's say the drop down list is in A1 (team), A2 (Status), A3(Project name), and A4(start date)
Please help me out!
I have to do this without using filter or pivot... they want it like this :/