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

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???

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

Use


=IF(T1=5,0,5)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jr2001" wrote in message
...
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???

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

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

=IF(T1=5,0,5)

HTH

"jr2001" wrote:

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???

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

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

"Toppers" wrote:


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

=IF(T1=5,0,5)

HTH

"jr2001" wrote:

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???