averageif

[Charlene Durand]

I have a companies earnings that if there are no earnings in that year i need to take the average of last three months.

SO if my column AO (TOTAL "Months average earnings") is 0 i want the column AQ to show me the average of the last three months so

what formula will i use i have this so far but it not working

=AVERAGEIF(AO12,"0",AW12:AY12)

 

[Kamolga]

The formula works, just get Div0 when it is different than 0.
To avoid that I surronder the formula with

=iferror([COLOR=#333333]AVERAGEIF(AO12,"0",AW12:AY12)[/COLOR],"")

As I have a 0 (number), I don't the the "" around 0 but it works with it.
You could also use

=if(AO12=0,average([COLOR=#333333]AW12:AY12),"")[/COLOR]

and if it does not work, I would test

=ao12=0

in a cell. If it says false, you might have 0.21 as a value but it is rounded to 0 on your view

 

[Charlene Durand]

Thank you so much