T
TMH0522
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
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