formulas fail to sum correctly. I have googled and checked all suggestions found to no avail. I suspect it is due to a mix of text vs. numbers within formulas that create the numbers to be summed.
here is one of the formulas: =IF(AND($B63="u",$C63="w"),IF(V63="rns",1.25,IF(V63="c",0,0)),"")...