Incorporate two data sets in one if/sum statement.

Razmig Varsam

I have one column where I want to sum the total amount of days of work, however, I want the sum column to be dynamic based on the %Complete column if the percentage is <100%.

 

 

I want the Sum column to show a total value anytime the % Complete is less than 100%.

Kennedy Stomps

Hi Razmig-- You could accomplish this iwith a SUMIF formula! This will allow you to only sum the values in the "Days of Work" column for which the "% Complete" value is <100%.

 

It would look like this:

 

=SUMIF([% Complete]:[% Complete], < 1, [Days of Work]:[Days of Work])

 

You'll want to adjust the ranges in the formula to match the ranges in your sheet. Hope this helps!

Razmig Varsam

Hello Kennedy, this worked out perfectly, thank you.

Razmig Varsam

Hello Kennedy,

 

For some reason the formula stopped working. Do I need to have any predecessor relationships to make this work?

Kennedy Stomps

Hi Razmig-- That's very strange! Can you share your sheet with me at Kennedy.Stomps@Smartsheet.com so I can help troubleshoot this? 

Razmig Varsam

Hello Kennedy, I shared the file over, thank you. It is weird as the formula worked the other day after you shared it. But I added a few new rows and now the formula doesn't work.