Production Capacity Planning; required hrs per week per department

I'm looking to modify the my capacity planning report.
In the attached columns A - S is the production report. Columns U to Y is the capacity report. (The acutal is much larger).

The capaicty report uses an array formula to calculate the required times in back log and in each week.
{=SUM(IF((HOrg!R1:R10>=U6-1)*(HOrg!R1:R10<=V6+1),HOrg!S1:S10,))*1.25}

I would like to modify this to include the numerical value in column A. In other words what are the required hours for the #2 rows and what are the required hours for the #1 rows.

Bascially i have three different sets of customers (#1 rows, #2 rows and #3 rows) and need to know, on a more macro level, which customers require more of my reources.