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!
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!