HowIF find AVGIF, "x=0"; when ERR 'DIV/O'?

asked 2017-04-19 13:12:42 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

When trying to run AVERAGEIF((a1:d1); "x=0") ... I get err: DIV /O.

How is it done...please enlighten me!

edit retag flag offensive close merge delete



@abi: Did you read a single word of the comments and answers concerning your recent questions? Why should someone assume you would read an answer to this question?

Lupp gravatar imageLupp ( 2017-04-19 13:30:12 +0100 )edit