Created IF functions - Need sum of results

  • Thread starter Thread starter TMH0522
  • Start date Start date
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
 
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.)
 
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)
 
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.
 
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)))
 
Back
Top