How can I do a SUMIFS (or similar) where columns/rows are transposed. In my data sheet data is organised like:
<tbody>
</tbody>
In my 2nd worksheet the columns/rows are transposed but I need to be able to sum the total of 3100 for Sourcing etc.
<tbody>
</tbody>
Any advise much appreciated.
3100 | 3587 | 2568 | 3800 | |
Talent | 200 | 320 | 124 | 256 |
Sourcing | 90 | 77 | 85 | 784 |
Media | 45 | 69 | 30 | 941 |
Talent | 426 | 25 | 24 | 4256 |
Sourcing | 497 | 74 | 85 | 287 |
Media | 569 | 36 | 26 | 365 |
<tbody>
</tbody>
In my 2nd worksheet the columns/rows are transposed but I need to be able to sum the total of 3100 for Sourcing etc.
Talent | Sourcing | |
3100 | ||
3587 |
<tbody>
</tbody>
Any advise much appreciated.