hey all
having some trouble with sumifs + offset formula. i have my data where it shows quantity by 2015, 2014, 2013.
Through a drop down in "sheet1" cell C17, i want to be able to show the quantity by month for states/provinces.
in "sheet1", cell D21 this is my formula:
=SUMIFS((OFFSET(Data!$A$59,3,MATCH(Sheet1!$C$17&Sheet1!$C$18,Data!$D$61:$V$61,0)-1,359)),Data!$D$62:$D$7225,Sheet1!$C21,Data!$B$62:$B$7225,Sheet1!D$19)
it is giving me #value error...can someone pls help?
thank you - attached is the sample file.
Bookmarks