CODEWITHSUNDEEP
excelexcel-formula
Sam
Sam

Reputation: 736

#DIV/0! when using an AVERAGEIF

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.

Upvotes: 2

Views: 425

Answers (1)

Rory
Rory

Reputation: 34035

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)

Upvotes: 2

Related Questions