Average only if certain status

Daniela Makowski

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 

sstikons

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

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.