Sum and If Function Problem with Excel 2007

D

David

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.
 
B

Bob Phillips

Is your conditional statement returning numbers that are really text, say
"1", "2", instead of 1 or 2. SUM won't like these.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
D

David

Thanks, Bob. I am using the "1", "2" in my conditional statement. The
numbers returned are from "0" to "8".
 
T

T. Valko

Remove the quotes from around the numbers. When you quote numbers Excel
evaluates them as text and text is ignored by the SUM function.

Don't do like this:

=IF(A1="x","1","0")

Do like this:

=IF(A1="x",1,0)
=IF(A1=1,"x",0)

Only text is quoted in formulas.
 
D

David

Bill, thank you very much. I had it backwards with the quote/text thing.
You are the best.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top