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.
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.