Forum Discussion
Average Sum Formula #DIV/0!
I am attempting to calculate the average n of days for x amt of cells that has a formula currently set to calculate n in days. i.e column n calculates =DATEDIF(B124,F124,"D")&" days " - the data i...
Because of the &"days" part, the formulas in column N return a text value.
AVERAGE ignores all text values.
Change the formula to =DATEDIF(B124,F124,"D")
I can't believe it was that easy of a fix! Thank you, so much, for helping!!HansVogelaar
