This formula works:
=SUMPRODUCT((('[Retail East Employees 12-31-05.xls]Active Employees Report
(As of)'!$D$13:$D$4000="VD")+('[Retail East Employees 12-31-05.xls]Active
Employees Report (As of)'!$D$13:$D$4000="PR"))*('[Retail East Employees
12-31-05.xls]Active Employees Report (As of)'!$F$13:$F$4000=D9))

I also want to add the sum of other cells (say h50 & h51...) to the above.
I can't get a syntax that give me the right answer.

In other words:
=H50 + H51+=SUMPRODUCT((('[Retail East Employees 12-31-05.xls]Active
Employees Report (As of)'!$D$13:$D$4000="VD")+('[Retail East Employees
12-31-05.xls]Active Employees Report (As of)'!$D$13:$D$4000="PR"))*('[Retail
East Employees 12-31-05.xls]Active Employees Report (As
of)'!$F$13:$F$4000=D9))
Any ideas?
Thanks as always.
WAL50