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

Use


=IF(T1=5,0,5)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"jr2001" <[email protected]> wrote in message
news:[email protected]...
> 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???

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

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