Average only if certain status

Daniela Makowski · 08/14/19

Hi, I am trying to create a formula that takes the average of a column called 'days in work', i only want to take the average if a different column 'status' has the status of the row shown as 'in progress'. I tried to do

IF ( status column = "days in work, average (...))

but it did not work. I need help figuring out the correct nesting sequence. Thanks

smartsheet question.PNG

sstikons · 08/14/19

Hi. Try using the AVERAGEIF formula. Your formula should look like this:

=AVERAGEIF(Status1:Status100,"In Progress",[Days in Work]1:[Days in Work]100)

Steven

Paul Newcome · 08/15/19

Steven is correct. AVERAGEIF is the perfect function for this particular case.

If you needed to include multiple ranges for different criteria though, there is no AVERAGEIFS, so you would need to use an AVG(COLLECT(.............)) instead.

Average only if certain status

Comments

Categories