I am working with a golf score card. I have a conditional statement that
gives points on a hole depending on the score. The If statements are working
perfectly, however, I can not sum the points correctly. I have used $ with
the column and row references and have taken the $ away and still receive the
same figure, "0" or zero. I get the zero regardless of the figures in the
conditional cells. I am using the basic =sum(b2:j2) for the 9 holes. Any
assistance would be greatly appreciated! Thank you.