Entering formulas in tables - using named ranges issue?

I am struggling with how to write a formula to provide a count of each text entry from a table to perform calculations with in new table. I can get it to work for the first row, but I think because I am using Named Ranges or something it copies the same exact formula for every row of the table. I am starting to think Named Ranges are not as useful as I had once thought! I created Named Ranges for each column of resources in the referenced table. But how do I force it to use a new column for each row in the Resource Type/Total WK Hours table?
Attachment 334873

Thank you!