Sumifs, countifs 2007

Hi All

Am trying to set up a larger spreadsheet as attached. I would like fomulas in Sheet1 b2:c4
which will populate the fields based on the data on sheet 2. eg cell b2, F1 is filtered by DUB so this counts the amount of times DUB apeears on sheet 2 broken down by 1 for FP ABS, twice for ROH EQ and once for ROH SW. Have been playing around with SUMIFS all evening but can't seem to get it right, would appreciate any help

thanks

Noel