Sumif /Sumifs

Brian Trotter

Having trouble getting the sumif function to work.

I have tried 2 versions, below 

=SUMIFS([Days Open]:[Days Open], Location:Location, [Repair Description]17)

=SUMIF(Location:Location, [Repair Description]15, [Days Open]:[Days Open])

The [Days Open] is a number calculated by subtracting 2 dates (the cells with functions)

The [Location] is an address

And the [Repair Description]15 - is just a reference to a cell that houses the address that is being searched for.

Note: when I input the actual (number) of days and and not have it calculate the formula above works...so it seems like the SUMIF function just will not calculate when functions are present.

 

Ultimately i'm trying to get the sum of the open days for a particular address...

Thanks,

Robert S.

Hello,

 

The SUMIF function is able to work with other formulas. In this case you would generally use SUMIF instead of SUMIFS, as there's only one criteria that you need it to match and SUMIFS is used when there are multiple criteria to match. That being said, either option should work and from the looks of it you've written them correctly. 

 

If you're receiving an error when this formula is written, you can check the Formula Error Messages article here to try to troubleshoot the issue (https://help.smartsheet.com/articles/2476176). If you'd prefer, you can also contact support through our Contact Us form for us to take a closer look at what could be causing this to not work (https://help.smartsheet.com/contact).