Summing Data From Selection In Columns Then Rows

[by76]

Hi All,
I am trying to consolidate some data, creating a summary set of numbers. I have resource types across the top of my page (always in row 1, from column B to Z), with approx 10 different resource types. Down the page I have project numbers in rows 2-100, always in column A, with approx 15 different project numbers.
I'd like to create a table showing the individual project numbers, and the amount of hours per resource per project.

I have tried sumif functions, however because the lookup is both across the page and down the page, I am struggling.

Hope you can help.

 

[kweaver]

Would you post a sample of your data and what you'd expect as results using XL2BB?
Also, what version of Excel do you run (please change your profile to indicate the version).

Thank you.