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 - Looking to take your Smartsheet knowledge to the next level and become an expert? Join the Smartsheet Guru Elite
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
Check out the Formula Handbook template!