Hi,
I was wondering if i could get some help on a formula that i am looking to get up and running, I have tried Countifs and Index but seem to be having no luck in getting a result back, MY dilemma is based on two sheets, The first being just raw CSV data (this is what i want the formula to look at) and the output table (This is where i want it to show the number of results found).
What i am trying to find is an overall count of how many incidents which were assigned to a certain person on a certain day, using the two tables below;
Data table
<tbody>
</tbody>
Output Table
<tbody>
</tbody>
MY formula i previously used but TNA was:
=Countifs('Data Table'!B:B,'Output Table'!B1, 'Data Table'!C:C, 'Output Table'!A2)
Let me know if anyone has any questions, Will be happy to help.
Thanks
I was wondering if i could get some help on a formula that i am looking to get up and running, I have tried Countifs and Index but seem to be having no luck in getting a result back, MY dilemma is based on two sheets, The first being just raw CSV data (this is what i want the formula to look at) and the output table (This is where i want it to show the number of results found).
What i am trying to find is an overall count of how many incidents which were assigned to a certain person on a certain day, using the two tables below;
Data table
A | B | C | |
1 | Incident | Name | Date Opened |
2 | INC0001 | Ben | 26/06/2019 |
3 | INC0002 | Bradley | 25/06/2019 |
4 | INC0003 | Tom | 26/06/2019 |
5 | INC0004 | Ben | 26/06/2019 |
<tbody>
</tbody>
Output Table
A | B | C | D | |
1 | Date | Ben | Bradley | Tom |
2 | 25/06/2019 | 0 | 1 | 0 |
3 | 26/06/2019 | 2 | 0 | 1 |
<tbody>
</tbody>
MY formula i previously used but TNA was:
=Countifs('Data Table'!B:B,'Output Table'!B1, 'Data Table'!C:C, 'Output Table'!A2)
Let me know if anyone has any questions, Will be happy to help.
Thanks