=IF(range="PD1", 1,0)

Summate the column where 1 or 0 appears and it will give you the total of PD1 or PD2, etc
Lazy way of doing it but there's another way, think its collate which i can't remember the exact steps