SUMIFS Formula issue

refogleman91066

I'm trying to write a formula in Smartsheet where it pulls the cost of an asset into a column if it matches the request and the replacement year:

=SUMIFS([Vessel Replacement Cost]@row, [Replace Year]@row = "2021", AND(Request@row = "Replacement"))

This is pulling ALL requests into the column where the asset is a replacement no matter the year.  Not sure what is wrong with my formula.  Maybe I am overthinking this???

Paul Newcome

Give this one a try...

=IF(AND([Replace Year]@row = 2021, Request@row = "Replacement"), [Vessel Replacement Cost]@row)

refogleman91066

That worked! Thanks Paul, I will be posting some more questions soon as I am working on a large project. 

Paul Newcome

Happy to help! 

 

Post away. I don't claim to know everything, but between everyone else on the community there isn't much we can't help with.