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