Remove Error on AVERAGEIFS Macro

[capson]

The Sub iAvarageIF works fine but I get the post back

#DIV/0!

I want to run the code and not get this post back I have tried changing

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

But this just gives me True or False in stead of the AVERAGEIFS

Thanks

Please Login or Register  to view this content.

[Cheetahke]

Try this:

Please Login or Register  to view this content.

[capson]

Hello Cheetahke,

I tried your code but I get the same as my the original code

[Cheetahke]

Can you post an example?