Question: Did I use averageif wrong

[ay123]

Hi, so I used the formula =AVERAGEIF(L2:L1000, ">10", G2:G1000) to calculate the average of my data, however, excel shows an error saying "AVERAGEIF caused a divide by zero error". But, when i tried =AVERAGEIF(L2:L1000, "11", G2:G1000) it did work. Does anyone know what went wrong? I'm kind of confused. Thanks!

 

[ay123]

Oh wow, it worked! Thank you so much ^^

 

[AhoyNC]

You're welcome. Thanks for the feedback.