Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Obtaining Multiple Results Using Index/Match Functions | Excel Worksheet Functions | |||
I created a Formula, OK, but can't get the results in the right ce | Excel Worksheet Functions | |||
Applying functions to web query results | Excel Discussion (Misc queries) | |||
Database Functions - Strange results | Excel Worksheet Functions | |||
functions are not displaying the results | Excel Worksheet Functions |