Sumifs - Referencing a Cell Instead of a Number/Word

[jamber17]

The formula I'm using is: =SUMIFS(Examples!$I:$I,Examples!$F:$F,"m6300-47101-0000",Examples!$C:$C,"=1",Examples!$B:$B,"*"&$A$1&"*")

This section in red is the only part of the equation that I'm having issues with. I'm creating a PO tracker, and the A1 box is the drop down box to select the year. The data for all of my PO's is all on a separate document named "Examples." When I change the equation to:

=SUMIFS(Examples!$I:$I,Examples!$F:$F,"m6300-47101-0000",Examples!$C:$C,"=1",Examples!$B:$B,"=2017")

Then, it all works perfectly. But I can't find a way to get it to reference the number in cell A1 as 2017. I've tried using different cells with and without a drop down box, but the main problem I'm having is referencing any cell at all.

Help please!

 

[jtakw]

Hi,

Can't you use just $A$1 without "*"&, &"*", and I don't think you need the = sign neither.

 

[jamber17]

Yes, THANK YOU! Such a simple solution!

 

[jtakw]

You're welcome, welcome to the forum.