I am trying to add the total for one column in which some cells have the
#REF! sign. My formula is:
=SUMIF(Data!A1:Data!A100,"<#VALUE!")
but the output is still #REF! and cannot display the value total. Does my
formula miss any?