Sum Offset on Data Table

[Candlepin20]

I’m trying to create a formula that can sum two or more columns in a data table based off of certain parameters.

Here is the formula I have now:

=sumif(table[Department Number], “110”, (offset(table(#headers],[2019-02],1,0,counta(table[2019-02],0),-2)))

The adjacent columns are 2019-01 and 2019-03. The formula “works” and sums. However, I can’t seem to get the formula to pickup both 2019-02 and 2019-01 data with the formula above.

What am I missing?

 

[maabadi]

Welcome to MrExcel Message Board.
Please upload your example file & Desired Results with XL2BB ADDIN (Preferable) OR upload it at free uploading site e.g. www.dropbox.com or googledrive or onedrive and insert link here.