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

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

It's for an invoice, so I need it total the numbers for all the variables I
was originally trying to use the formula IF(a2=Half Day,"$150",IF(a2=Full
Day,"$300",IF(a2=LATE CANCELLATION,"$150"))) There were two problems with
this. First, it wasn't recognizing the text as a Logical Test. When I
reversed and used the numbers for a logical test, then the formula worked,
but I couldn't use it casue the 150 biling amount is applicable in two
instances.

I then created a code vale. the 1,2,3 and made the IF formulas based on
those. IF(a1=1,"Half Day",IF(a1=2,"Full Day",IF(a1=3,"Late Cancellation")))
for column b and a1=1,"$150 etc....for columc C. Now I need for the
numbers in colomn c to total, but they are not being recognized as
independent values.

:( very frustrated i hope that better explains what I was trying to do.

"JP" wrote:

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

Hi

The formula (for column B???) must be like:
=IF(a2="Half Day",150,IF(a2="Full Day",300,IF(a2="LATE
CANCELLATION",150,0)))


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"TMH0522" wrote in message
...
It's for an invoice, so I need it total the numbers for all the variables
I
was originally trying to use the formula IF(a2=Half Day,"$150",IF(a2=Full
Day,"$300",IF(a2=LATE CANCELLATION,"$150"))) There were two problems with
this. First, it wasn't recognizing the text as a Logical Test. When I
reversed and used the numbers for a logical test, then the formula worked,
but I couldn't use it casue the 150 biling amount is applicable in two
instances.

I then created a code vale. the 1,2,3 and made the IF formulas based on
those. IF(a1=1,"Half Day",IF(a1=2,"Full Day",IF(a1=3,"Late
Cancellation")))
for column b and a1=1,"$150 etc....for columc C. Now I need for the
numbers in colomn c to total, but they are not being recognized as
independent values.

:( very frustrated i hope that better explains what I was trying to do.

"JP" wrote:

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

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