Calculating average difference in dates between two columns

Hi I am trying to find the average time to complete a task without adding additional columns in my sheet. I would like to set it up in the sheet summary for easy reporting.

In excel I would use the following formula. If a cell is blank the row will not be calculated as part of the average.

=SUMPRODUCT((I2:I52)-(E2:E52),--(E2:E52 > 0),--(I2:I52 > 0))/SUMPRODUCT((ISNUMBER(I2:I52))*ISNUMBER(E2:E52))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!