I have a formula that works for the sum of visible rows in one column if criteria in another column is met. So, like sumif on visible cells of a filtered set of data.
My issue is I want to add more than one column. I want to specify a range of columns. Instead of adding DX I want to add Columns DX, DY, DZ, etc. I know that I could add that formula to itself and modify for each column, but I was hoping for a better solution.
Code:
=SUMPRODUCT(SUBTOTAL(9,OFFSET(Monthly_Detail_Instantis!DX$2,ROW(Monthly_Detail_Instantis!DX$2:Monthly_Detail_Instantis!DX273)-ROW(Monthly_Detail_Instantis!DX$2),0)),--(Monthly_Detail_Instantis!D$2:Monthly_Detail_Instantis!D273=H9))
My issue is I want to add more than one column. I want to specify a range of columns. Instead of adding DX I want to add Columns DX, DY, DZ, etc. I know that I could add that formula to itself and modify for each column, but I was hoping for a better solution.