How to get rid of #DIV/0! Office 2013

[mlbarry]

Here is the formula:

=AVERAGEIF(Table1[Customer '#],'Customer Summary'!$A$2:$A$50000,Table1[Days

I tried =IFERROR(AVERAGEIF(Table1[Customer '#],'Customer Summary'!$A$2:$A$50000,Table1[Days],"") it will not calculate.

 

[MARK858]

Really the AverageIf works without it's closing parentheses and Days without it's closing ].

 

[BlueHornet]

If you're not going to take the advice that I gave you on the first day that you asked the question, then I've got no more time for this. I'm out.

 

[Michael M]

I'd say the OP's formula is using a "<" symbol.
If the "<" is preceeded / followed by a space, it will treat it as HTML and the rest of the formula will not appear.

 

[Joe4]

Here is what Michael M is referring to: https://www.mrexcel.com/forum/about-board/680917-formulas-not-appearing-completely-read.html

 

[MARK858]

Duplicate, please see next post

 

[MARK858]

The < symbol (followed by a letter btw for rest of the formula to vanish) and the full formula normally show up if I do a reply with quote (because I am in WYSIWYG mode) and doesn't in either of the OP's posts.

Just testing below to make sure that nothing has changed in this thread.

=IF(A1<B1,"X","Y")

Edit:
Yes, I can still see the full formula above in reply with quote but not in the OP's posts.

 

[mlbarry]

I re-formatted to column headers on Table1 to "General" and removed a space in the "Days Past Due" header and it worked. I still do not understand because it was working until the IFERROR was added.

=IFERROR(AVERAGEIF(Table1[Customer '#],'Customer Summary'!$A$2:$A$50000,Table1[Days Past Due]),"0")

Thank you all for your help.