Sum multiple columns with Sumif Index Match

[erniepoe]

Hi All,

I am trying to sum all columns and rows when the dates in row 4 contain the year in cell c22, as well as when column AO matches the criteria in A23. When I replace the "*"&C22&"*" with just "2024" I get the sum of the first column (January), but not the full year.

Any idea how I can rejigger the formula to find the full year? This would be referencing another workbook, so if the values error out when that workbook is closed wouldnt be the end of the world, but if the formula can solve that problem as well, would be most appreciated.


=SUM(SUMIFS(INDEX('[File.xlsx]Current Rent Projections'!$D:$AM,0,MATCH("*"&C22&"*",'[File.xlsx]Current Rent Projections'!$D$4:$AM$4,0)),'[File.xlsx]Current Rent Projections'!$AO:$AO,A23))

 

[SunnyAlv]

Can you include a picture or table of what the data looks like to make it easier for someone to know the achievements you want further?