Hi, i am trying to populate a table using a raw data to count using multiple criteria in a data range. Please refer to the attached file. Based on the team and task, i would like to count following a criteria to dertermine the number of occurrence based on the dates given. Also needed to search the count following a criteria for a specific date range.
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL span=3><COL><COL span=6></COLGROUP>
Example:
Team Alpha - Inbound - Date (4/10/2014) = 1
Team Charlie - Inbound - Date (4/10/2014) = 0
Team Delta - Outbound - Date (Next 4-6 day) = ?
I have tried multiple formulas but didn't work (Index/ Match, Vlookup, Countif, Sumproduct). Need you assistance on this especially on the date range.
Thank you.
Team</SPAN> | Task</SPAN> | Date</SPAN> | ||||||||||
Team</SPAN> | Task</SPAN> | Date</SPAN> | Today</SPAN> | Next 2 -3 days</SPAN> | Next 4 - 6 days</SPAN> | > 6 days</SPAN> | ||||||
Alpha</SPAN> | Inbound </SPAN> | 4/11/2014</SPAN> | Alpha</SPAN> | Inbound</SPAN> | 1</SPAN> | |||||||
Charlie</SPAN> | Outbound</SPAN> | 4/12/2014</SPAN> | Outbound</SPAN> | |||||||||
Delta</SPAN> | Data</SPAN> | 4/10/2014</SPAN> | Data</SPAN> | |||||||||
Alpha</SPAN> | Outbound</SPAN> | 4/12/2014</SPAN> | Charlie</SPAN> | Inbound</SPAN> | ||||||||
Alpha</SPAN> | Outbound</SPAN> | 4/15/2014</SPAN> | Outbound</SPAN> | |||||||||
Delta</SPAN> | Data</SPAN> | 4/13/2014</SPAN> | Data</SPAN> | |||||||||
Charlie</SPAN> | Inbound </SPAN> | 4/14/2014</SPAN> | Delta</SPAN> | Inbound</SPAN> | ||||||||
Charlie</SPAN> | Inbound </SPAN> | 4/11/2014</SPAN> | Outbound</SPAN> | |||||||||
Charlie</SPAN> | Inbound </SPAN> | 4/12/2014</SPAN> | Data</SPAN> | 1</SPAN> | ||||||||
Delta</SPAN> | Inbound </SPAN> | 4/13/2014</SPAN> | ||||||||||
Alpha</SPAN> | Inbound </SPAN> | 4/10/2014</SPAN> | Today = 4/10/2014</SPAN> |
<TBODY>
</TBODY><COLGROUP><COL><COL><COL><COL span=3><COL><COL span=6></COLGROUP>
Example:
Team Alpha - Inbound - Date (4/10/2014) = 1
Team Charlie - Inbound - Date (4/10/2014) = 0
Team Delta - Outbound - Date (Next 4-6 day) = ?
I have tried multiple formulas but didn't work (Index/ Match, Vlookup, Countif, Sumproduct). Need you assistance on this especially on the date range.
Thank you.