Ignore zeros with AVERAGEIF but in columns with specific text

[leyagaco]

Hi,

I'm trying to get the average from the R column but only if it contains an specific text in the D column AND ignore zeros on column R, I only got this so far =AVERAGEIF(D:D,"Production Operator",R:R) but I am not sure how to add the "ignore zero" to the formula, please help, thank you!

 

[mehidy1437]

Try this & advise
Updated

=AVERAGEIFS(R:R,D:D,"Production Operator",R:R,"<>0")

 

[leyagaco]

Thank you, I tried but it says there's an error in the formula

 

[mehidy1437]

Updated

=AVERAGEIFS(R:R,D:D,"Production Operator",R:R,"<>0")

 

[leyagaco]

I tried that and now it says I entered too many arguments

 

[leyagaco]

I tried that and now it says I entered too many arguments

Sorry, I didn't notice you added something to the formula, now it worked, thank you!!!

 

[mehidy1437]

you are welcom