Invalid Data Types
I believed I've fixed the formula to correct the @cell invalid data type error and instead it returns a blank cell. However, I've used the following formulas to try and get the average from a column in my spreadsheet but I keep getting an invalid data type error in the sheet summary formula..Any suggestions?
=AVG([LE Total Days]:[LE Total Days])
=AVG(COLLECT([LE Total Days]:[LE Total Days]), ISNUMBER,(@cell)))
Help Article Resources
Check out the Formula Handbook template!