This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I want to use a rollup to get an average of the existing numbers, but not all the fields in the column I want an average from have an existing number and return NaN. I want the rollup to ignore NaN.
Yep, full column comes up blank and the formula automatically turns into IF( ISERROR( x/y )=0)) only - just gets rid of the rest of the formula after saving.
Unfortunately that didn’t work - just got a fully blank column.
Maybe more context will help! I have one tab that has a function column =x/y, and in another tab I need the average of these as part of a rollup. I have tried using blanks where it retur...