Hi all,
I want to sum multiple cells in a column if the title is a certain value.
A B C D E
1 2008 2009 2010 2011 2012
2 23 45 65 32 11
3 10 10 10 24 22
4 32 43 24 76 43
5 82 13 57 99 34
6 12 43 21 88 56
I wanted a value for row 2, year 2008 through 2012 separately
I also wanted a value for row 3 for each year.
The problem arises when I want row 4-6 summed for each year.
I am linking to another tab which specifies the year. on the left and the category (rows) on the top.
Thanks in advance!
Bookmarks