Hi,

I'm using excel 2007 and need to create a pivot table that summarizes the blank cells. Below is a simple version of my data set. I have multiple people and multiple tasks that must be completed. The tasks are linear and go from the vendor to manager. Vendor A completes task 1, then manager completes task 2. In the real spreadsheet I have 5 different tasks that must be completed by 5 different groups and need to be able to see at a glance who has how many tasks and how long they have had them. I can figure out how to add in which sites they have, but first I need to be able to see how many tasks they have in their queue. The information changes daily, so I don't want to have to input a bunch of formulas or counts daily.

I need to figure out how to get these results: Vendor A has to complete task 1, for 1 site, site 103. Vendor B has to complete Task 1 for site 102. Vendor C has 0 tasks to complete. Manager George has to complete task 2 for 2 sites, 104 & 105. Managers Bob and David have 0. So the results would look something like this:

Ven A 1
Ven B 1
Ven C 0

Bob 0
Fred 0
George 2


pivot example.JPG