Need help with sumifs

%3CLINGO-SUB%20id%3D%22lingo-sub-2082868%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20sumifs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2082868%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20with%20Sumifs%20formulae.%20I%20am%20not%20able%20to%20link%20a%20cell%20in%20the%20criteria%20syntax%20of%20the%20sumifs%20function.%20for%20example%3A%3CBR%20%2F%3ESUMIFS(%24D%2432%3A%24AF%2432%2C%24D%2431%3A%24AF%2431%2C%222011%22%2C%24D%2430%3A%24AF%2430%2C%22Neiva%22)%3CBR%20%2F%3EInstead%20of%20%222011%22%2C%20I%20want%20to%20link%20it%20to%20the%20cell%20so%20that%20it%20gets%20automatically%20update%2C%20how%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2082868%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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?

1 Reply

@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")