Need help with sumifs

[irtizaali212]

Hi, 

I need help with Sumifs formulae. I am not able to link a cell in the criteria syntax of the sumifs function. for example:
SUMIFS($D$32:$AF$32,$D$31:$AF$31,"2011",$D$30:$AF$30,"Neiva")
Instead of "2011", I want to link it to the cell so that it gets automatically update, how to do this?

[#2]

@irtizaali212 

Let's say you enter the year in cell B1. The formula becomes

=SUMIFS($D$32:$AF$32,$D$31:$AF$31,B1,$D$30:$AF$30,"Neiva")

If that doesn't work, try

=SUMIFS($D$32:$AF$32,$D$31:$AF$31,B1&"",$D$30:$AF$30,"Neiva")