Need to count Blank cells instead of data cells in Pivot table

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

Can you post a sample spreadsheet?

How about one of these sample solutions - See one that works for you?

thanks for the reply, but none of those give me the correct counts. The Manager doesn't belong to the Vendor. I need separate counts of remaining tasks for the vendor and the manager. With the sample data I put in above, these should be the results:
Ven A 1
Ven B 1
Ven C 0

Bob 0
Fred 0
George 2

I'm trying a different approach now, to count the blank cells within a range based on the previous cell not being blank. But I need it to countblank if the range is greater than zero. Here's the formula I'm attempting to use, but get the #value. S4:S14 is my range that I need to count if the range of R4:R14 is greater than zero. What am I doing wrong?

=IF(R4:R14">0",(COUNTBLANK(S4:S14)))

My temp solution is =COUNTBLANK(S4:S14)-COUNTBLANK(R4:R14). it seems to work.

Ah, I see where I miss interpreted your initial post. I don't think I can solve this with the sample you provided. I would need a sample file with all 5 groups and tasks represented. Please post the sample in excel - no pictures, and sanitized of personal or business sensitive info as required.

In the picture you provided in your first post - Is this the required layout for the data or can it be arranged differently?