What are the formulae that you are using, you might be creating text not
number results.

--
HTH

Bob

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

"TMH0522" wrote in message
...
I created IF functions for both the outcome and fee columns. Now I need to
be able to get the sum of the fees and wehen I try to use the sum
function,
it gives me $0. How do extract the value out of the cell and total the
numbers? I tried doing an a1=a2 and even though the a2 column is showing a
number without the function formula, it still is not ttreating the numbers
as
values and will not sum them.

Sample of my table below:

Code Outcome Fee

3 LATE CANCELLATION 150
1 HALF DAY 150
4 PARKING 75
2 FULL DAY 300