Hi,I posted this request for help not too long ago but didn't clearly
explain what is needed. When text is entered into a field (currentgoal1,
currentgoal2 - each equaling 1), the formula needs to look at a
different field (point1, point 2 - each holds a list box of with points
1, 3, 5, or NA) to see if "NA" was chosen. If NA was chosen (rather than
a point, 1, 3, 5) then the goalcount (total number of populated
currentgoal fields) needs to subtract 1 from goalcount. currentgoal 1 =
1 pointcurre...