Thank you gebobs. You are correct. I would like to display 6, 10, 8 when I select year 2015. In my subsequent query, I'd like to filter for year 2016 and but not include site 1Y (row 1Y removed) since it was already included in year 2015.

As for sample sheets, I tried to include them as tables in the text of this message but tables do not retain the formatting (I think). I did not submit as an image because I do not know how to link the image to a url. So I was stuck sending the spreadsheet as an attachment with the samples illustrated in the spreadsheet.