Working on a project where I want to put a total in a column based on if an asset needs a rehab. I would like for the formula to find the year and if it matches with the column, put the total in that cell.
Here's what I've got:
=SUMIF([Next Overhaul Year]2:[Overhaul 15]2, =[SFY2021]1, [Dry Dock Cost]@row)
Getting an invalid argument set error message.
Here's a screen shot for reference: