How to Fix #DIV/0! Error

[EverClever]

Hello,

The following formula has a #DIV/0! error message. Currently all of the Cells involved in this formula are blank but will eventually have numbers in some or all of them.

=IF(SUM(Q639:Q659)="","",SUM(Q639:Q659)/COUNTIF(Q639:Q659,">=1"))

I edited the formula to this and I got a "Too Many Arguments for this Function" message; =IFERROR(SUM(Q639:Q659)="","",SUM(Q639:Q659)/COUNTIF(Q639:Q659,">=1"),"")

Thank you,

Patrick

[TMS]

Untested:

Please Login or Register  to view this content.

Regards, TMS

[TMS]

I suspect that this doesn't work:

Please Login or Register  to view this content.

A sum isn't going to equal nothing, it will equal a numeric value.

[EverClever]

TMS,

It worked! Then I figured that the IF="","", wasn't working so I eliminated it and your changes still worked:

=IFERROR(SUM(Q639:Q659)/COUNTIF(Q639:Q659,">=1"),"")

Thanks Much!

Patrick

[TMS]

You're welcome. Thanks for the rep.