Sumif same text or group function?

[benzineo]

Hi,

I have a PivotTable that collects schedule data for almost 500 people that work for our company from another source if i refresh, here we can see how many absence hours they have and how much time they have worked in detail.

The problem is that some people's name show up multiply times in the column labels becuase they have been working in different teams during the period i want to pull out data for.

What i need is one total for each person instead of 2-3 totals.

Can i use some sumif "same" function or simular to group this data automaticly so i only get one total for each name? Maybe some macros out there?

There is to many names to use the exact frase so what i need to know is how to get excel find simular columns and count them together for me.

I use excel 2010 by the way.

//Linus in Sweden

 

[jim may]

In what form is the original data? Can you (on the side) sort the data by employee name or number? If so then afterwards run the Subtotal feature under Data, use employee name in the "at each change in" box, then sum, or count. No Pivot table needed. Good luck Jim

 

[benzineo]

problem solved internally now we have formula that counts the values in the column to the left if it have the same headline and do a total

example:

=IF(G37=F37;F83+SUM(G64:G67);SUM(G64:G67))