Hi All,
I'm not an excel expert and I have limited knowledge.
I have two sheets of data.
The first sheet of Data looks like this
<tbody>
</tbody>
On another sheet I want excel to return
<tbody>
</tbody>
I've tried using vlookup with sum ifs
=SUM(VLOOKUP(A3,'User Productivity Summary'!C:M,{3,9},FALSE))
But this will only count the first row of each user in my source data.
Thanks
Paul
I'm not an excel expert and I have limited knowledge.
I have two sheets of data.
The first sheet of Data looks like this
Name | CallIN | Abandoned | Outbound |
Joe | 30 | 3 | 25 |
Joe | 20 | 7 | 12 |
Joe | 15 | 2 | 2 |
Ben | 3 | 17 | 0 |
Ben | 8 | 2 | 15 |
Mo | 12 | 15 | 7 |
<tbody>
</tbody>
On another sheet I want excel to return
Name | CallIN | Abandoned | Outbound |
Joe | 55 | 39 | |
Ben | 11 | 15 | |
Joe | 12 | 7 |
<tbody>
</tbody>
I've tried using vlookup with sum ifs
=SUM(VLOOKUP(A3,'User Productivity Summary'!C:M,{3,9},FALSE))
But this will only count the first row of each user in my source data.
Thanks
Paul