SUMIF Formula
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:
Comments

https://help.smartsheet.com/function/sumif

=SUMIF(range, criterion,[sum_range])
Range: The range to analyze
Criterion: The criteria for said range
[sum_range]: in hard brackets because it is optional. If included, this will be the range summed up. otherwise, first range will be summed.
*(The number of cells in both ranges must be equal to each other)

Beyond that, I cannot write your formula as I don't understand how you are associating the date with the values.

I'm trying to put a value in a cell if any of those years in that range equals the year in the column. Does that help?

So the sum range is where I'm going wrong. The "range" for me is just a single cell. So, I regrouped and tried this formula:
=IFERROR(IF(MATCH(2021, [Next Overhaul Year]@row:[Overhaul 15]@row), [Dry Dock Cost]@row, 0), 0)
It works for the first cell, but when I drag it down, it's not working properly.

That didn't work either. Lemme try a different approach and post below.

I'm trying to budget out how much it will cost to pay for dry docks for each boat each year. The cost is set and I have the date for the next scheduled dry dock and each boat is on a 2, 3, or 5 year cycle, depending on the boat. Is there a way to project out by year based on the dry dock cycle? I started with this formula:
=SUMIF([Next Overhaul Year]2, [SFY2021]$1, [Dry Dock Cost]@row)
So, I want to calculate for 2022  2050. Screenshot below for reference.

=SUMIF([Next Overhaul Year]:[Next Overhaul Year], 2021, [Dry Dock Cost]:[Dry Dock Cost])
This will work for 2021, but it will be a pain to drag it, as you will have to type it in every time. Also you will have a long list of historical projections I would imagine are rather useless. I would name the columns you currently have posted as the year as 130 or something similar so it isn't confusing when the years don't match up, then use this formula in the first row:
=year(today())+1
Then post the expected results in the second row as the formula
=SUMIF([Next Overhaul Year]:[Next Overhaul Year], year(today())+count([1]$1:[1]1), [Dry Dock Cost]:[Dry Dock Cost])
or something similar. This way you can drag the formula easily, and it will always show the next 30 years.
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.1K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 450 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 34 Webinars
 7.3K Forum Archives