Average with excluded values
Hi !
I would like to calculate an average with excluded values.
I use a gantt on which I have frozen a baseline. With the baseline, we can see in the "variance" column whether we are behind or ahead. But the values in the variance column are either positive or negative.
I would like to calculate the average of the negative values only.
I used the following formula: =ABS(AVEGERAGEIF({variance}; <0 ) but it does not work
Need help please,
Léonie
Answers
-
@Léonie You are missing a closing parenthesis.
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
@Darren Mullen Thank you,
I checked, I have it in my formula, just forgot it here..
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!