I have a worksheet that I that I want a total of column in another worksheet =SUMIF('LAD 1099 Smartlist'!A:A,'W9-1099'!A9,'LAD 1099 Smartlist'!J:J) which I was able to get the only thing I am having trouble with is I want it to only take the sum of the column if it is in that month of the column name so I want it to depend on another column in that worksheet (Smartlist) column H which the date is formatted like 1/25/2017. Column H is in the Smartlist worksheet. So I believe I need to use SUMIFS but everything I have tried is not working.
Bookmarks