update formulla

Jomana

I need help. I have a formula to calculate the average duration in days and I have used the formula below successfully. I need to update it to include the word "days":

=AVERAGEIF({Field Trouble Report (FTR) Tracking Sheet- Range 1}, "Completed", {Field Trouble Report (FTR) Tracking per De Range 2})

Thank you in advance!

bisaacs

Hey @Jomana,

You can just use a + to add "days" at the end:

=AVERAGEIF({Field Trouble Report (FTR) Tracking Sheet- Range 1}, "Completed", {Field Trouble Report (FTR) Tracking per De Range 2}) + " Days"

Hope this helps!