LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Created IF functions - Need sum of results

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Obtaining Multiple Results Using Index/Match Functions Archie999 Excel Worksheet Functions 1 March 3rd 07 07:57 AM
I created a Formula, OK, but can't get the results in the right ce To Old To . . . Excel Worksheet Functions 8 February 18th 07 06:59 AM
Applying functions to web query results ExcelTina Excel Discussion (Misc queries) 0 November 29th 06 10:36 PM
Database Functions - Strange results Bob Excel Worksheet Functions 3 June 8th 06 08:48 PM
functions are not displaying the results [email protected] Excel Worksheet Functions 1 February 16th 06 01:27 PM


All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"