Hi
I have a spreadsheet, with a lot more data than below spanning quite a few years. I want to add a summary page to show the totals by individual by year. As it's a moving piece i didn't want to put a YTD total on and use a sumif, i was wondering if there is a way of looking across a row and picking up all the 2019's by Boris and summing it?
<tbody>
</tbody>
I have a spreadsheet, with a lot more data than below spanning quite a few years. I want to add a summary page to show the totals by individual by year. As it's a moving piece i didn't want to put a YTD total on and use a sumif, i was wondering if there is a way of looking across a row and picking up all the 2019's by Boris and summing it?
2019 | 2019 | 2018 | 2018 | |
Boris | 400 | 400 | 6500 | 600 |
Carly | 500 | 6500 | 3000 | 800 |
Megan | 640 | 502 | 5031 | 160 |
Harry | 514 | 545 | 6565 | 555 |
<tbody>
</tbody>