Summing Multiple Rows of Data with Criteria

Hey All,

I am trying to find an easy formula for summing multiple rows with criteria.

I am looking for sales from all categories in 2015 only

Category 12/31/2014 3/31/2015 6/30/2015 9/30/2015 12/31/2015 3/31/2016
A $1 $1 $1 $1 $1 $1
B $1 $1 $1 $1 $1 $1
C $1 $1 $1 $1 $1 $1
D $1 $1 $1 $1 $1 $1


Thanks for the help,

Nick

Try

=SUMPRODUCT(($B$2:$G$5)*(YEAR($B$1:$G$1)=2015))