Sumproduct or sum(if( etc.

[srizki]

I have sites names in column A, there are two sites and employees names in column B, some employees may be working on both sides, I need to create a table that shows total of each site per employees. So the formula should work like, sum of hours in column F if site is abc and employee is def.

my resultant list is like heading of site and then employees, for both sites.

I hope it makes a sense.

 

[texasalynn]

Take a look at pivot tables - that should do what you want

 

[srizki]

Thank you,
Why did I not think of that?