CODEWITHSUNDEEP
excel-formula
khutch
khutch

Reputation: 3

AVERAGEIFS returning #DIV/0

So I am creating a database which compares demographics of patients among other things. I am trying to use the AVERAGEIFS function to find the mean operative time for specific surgeries for only patients who have a BMI of above 40.

=AVERAGEIFS(Data!P2:P255, Data!C2:C255, "*TYPE OF OPERATION*",Data!G2:G255, ",>40")

Column P contains the Operative time, C contains the type of operation and G contains the BMI of the patient. I keep getting a #DIV/0 error with this code. What am I doing wrong?

Upvotes: 0

Views: 772

Answers (1)

J. D.
J. D.

Reputation: 1561

There should not be a comma in the last criteria ",>40". This should be ">40"

Also, if you fix the above and still get the same error, it is possible that none of the items in column C and/or G match your criteria.

See Microsoft Documentation on AVERAGEIFS

enter image description here

Upvotes: 1

Related Questions