If I try to use the max function on a column with a cell with #REF!, I get
#REF! as my result. I tried doing an if statement saying if a cell = #REF!
make it a 0 but it's not working. Anything else I can do?