#DIV/0! when using an AVERAGEIF

user_15451183 0
Viewed 131

enter image description here

I am using the formula shown in the picture and what I want it to do is average the MinOscilation value categorised by date. That way for example I can get an average for everything on 30/04/2021, 04/05/2021 and like that) but when I try to do that I get an #DIV/0! error and I'm not sure exactly what I am doing wrong.

excel-formula excel
1 Answers

The syntax you are using is for the AVERAGEIFS function. So either use that, or switch the arguments to the correct order for AVERAGEIF:

=AVERAGEIF($G$22:$G$36,G40,$H$22:$H$36)
user_36119890
Related