Getting Error #DIV/0 for empty cells

[JJFletcher]

Hello all,

Getting #DIV/0 error for empty cells and each cell has the below formula:

Please Login or Register  to view this content.

Any thoughts?

Regards,

John

[Pepe Le Mokko]

Without seeing data, try the AVERAGEIF function to exclude 0 values

[JJFletcher]

Hi Pepe,

When using AVERAGEIF funtion I get an error that says to many arguments...

Regards,

John

[Pepe Le Mokko]

Have you tried AVERAGEIFS ?

[JJFletcher]

Hi Pepe

Thanks for your reply...

I will give it a try

Regards,

John

[JJFletcher]

Hi aLL,

I tried the AVERAGEIFS and still have the #DIV/0 errors in the cells

Regards,

John

[oeldere]

then show the formula you have used, or even better post the excel file, without confidentional information.

[JJFletcher]

Hello Oeldere,

Here is the formula used:

Please Login or Register  to view this content.

I have used the IFERROR and still get an error: "You've entered to many arguments for this function"

Please Login or Register  to view this content.

I have used the AVERAGEIF and still get an error - "You've entered to many arguments for this function"

Please Login or Register  to view this content.

I have used the AVERAGEIFS and still get an error - "You've entered to few arguments for this function"

Please Login or Register  to view this content.

Regards,


John

[oeldere]

then show the formula you have used, or even better post the excel file, without confidentional information.


With average you can use "Maximal 255 extra value", so that won't be the problem


The syntax of the averageif should be

"Syntaxis

GEMIDDELDE.ALS(bereik, criteria, [gemiddelde_bereik])"


edit

averageif(range, criteria, [average_range])"

[bakerman2]

Hi John, try this.

Please Login or Register  to view this content.

@ oeldere

Since this is an English forum i strongly believe that only a few people here will understand "GEMIDDELDE.ALS(bereik, criteria, [gemiddelde_bereik])" .

[JJFletcher]

Hi Bakerman2,

Outstanding performance as usual.... The code works perfect.



Regards,

John

[bakerman2]

You're welcome and thanks for rep+.