CODEWITHSUNDEEP
excelexcel-formulaexcel-2016
Shobi
Shobi

Reputation: 105

Averageif works if i try separately but averageifs gives me an error #DIV/0 though there is data

It's a simple formula with two conditions.

When i try =averageif(B:B,"CAT 2,A:A) or =averageif(C:C,"Total Loss",A:A). It works, but when i try with =averageifs(A:A,B:B,"CAT 2",C:C,"Total Loss") i get an error #DIV/0. I have tried trimming the columns, removing any blanks but still the same error.

What can be the issue here?

https://i.sstatic.net/pk3Xm.jpg

Upvotes: 0

Views: 138

Answers (1)

BigBen
BigBen

Reputation: 49998

Try adding wildcards around your criteria. You may have leading or trailing spaces or some other non-visible character(s) in your data:

=averageifs(A:A,B:B,"*CAT 2*",C:C,"*Total Loss*")

Upvotes: 2

Related Questions