How do i add cell values that are returned via a formula

[jr2001]

I am using a combo box to select A-F grades. I am then using the formula
=IF(T1=5,"0","5") to return a value of 0 or 5 credits. I would then like to
add those cells up to give a total of credits. However apparently normal
"sum" does not work, even though the value that is displayed in the cell is a
number. (5 or 0). HELP???

 

[Bob Phillips]

Use


=IF(T1=5,0,5)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Toppers]

Change to so the values are numeric not text - SUM will then work:

=IF(T1=5,0,5)

HTH

 

[jr2001]

Thanks so much!!!! That was too easy!

Change to so the values are numeric not text - SUM will then work:

=IF(T1=5,0,5)

HTH