Job Labor Count using Piivot

[JNEWMAN]

Hi all
I am going nuts trying to create a pivot to total how much resource was used in each job, I have attached a small example to show what I mean. Sheet1 will show the data and Sheet2 shows what currently get with the simple pivot I am running and also what I'm trying to get as I only want to total how many heads where used in each job, not how many times they recorded it. I am running this on 2007 in case that makes a difference.

Any help much appreciated.

Thanks
JNEWMAN

[hemesh]

In C1 of sheet 1 where you have actual data add a header as count
then in C2 copy paste below and drag down

=IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2)>1,0,1)

now create a pivot table and in Values field keep count

hope that helps

[JNEWMAN]

Hi hemesh
That done the job my friend and I greatly appreciate your response. I never know how to change the status to SOLVED but if anyone is reading this it is now resolved..

Many thanks
JNEWMAN

[hemesh]

You are welcome and thanks for the feedback.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

I would appreciate if you consider clicking small add rep icon at the bottom left corner of the post who helps you in solving your queries, this add to their reps

[JNEWMAN]

Hi Hemesh
I found the add reputation no problem but I still can't see where to mark SOLVED anywhere,

[hemesh]

please check post #4