I'm kind of an Excel newbie and am trying to figure something out with SUMIF. I googled around a bit and found out about INDIRECT although I dont think its exactly what I need.
I have a SUMIF formula that is referencing a separate spreadsheet.
The sum_range portion of it is '[Worksheetname.xlsx]Sheetname'$359:$359)
What I am trying to do is change the $359:$359 to a value in the current spreadsheet. ie. I populate cell B61 with the number 475, so the formula could instead be: '[Worksheetname.xlsx]Sheetname'$B61:$B61) which would effectively yield '[Worksheetname.xlsx]Sheetname'$475:$475). I want it to reference a cell so I can drag the formula down and have it change to whatever numbers are in B62, B63, etc...
Does this make sense and is it possible?
Thanks
Bookmarks