the named range refers to
=Lists!$A$2:$A$34
look in namemanager on the insert tab

sumifs explained here
http://spreadsheets.about.com/od/som...p-Tutorial.htm