I'm not clear on what you need, could it be

=SUMIF(B:B,"LATE CANCELLATION",C:C)

In other words, "look for the words LATE CANCELLATION in column B and
add up the corresponding values in column C"

This would give you a sum total of all the late cancellation fees.

HTH,
JP

(ps- You should probably adjust the ranges to account for your real
data.)


On Jan 8, 9:09*pm, TMH0522 wrote:
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