Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat Pat is offline
external usenet poster
 
Posts: 210
Default 2 colums needs to sum and the anwsers needs to divide to get a pe

Incentive Credit Billed charge
($1.37) 4.6
$0.00 2.05
($0.05) 0.25
($1.42) $6.90 -4.85915493

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default 2 colums needs to sum and the anwsers needs to divide to get a pe

I think you need to expand a bit more on what you want - this makes no
sense to me.

Pete

On Oct 12, 6:26*pm, Pat wrote:
Incentive Credit * * * *Billed charge *
($1.37) 4.6 * *
$0.00 * 2.05 * *
($0.05) 0.25 * *
($1.42) $6.90 * -4.85915493


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat Pat is offline
external usenet poster
 
Posts: 210
Default 2 colums needs to sum and the anwsers needs to divide to get a


ok I need A and b to sum and the answers to be divide to get the% of the
two sums there are 3 rows in each column to sum
I hope this helps

"Pete_UK" wrote:

I think you need to expand a bit more on what you want - this makes no
sense to me.

Pete

On Oct 12, 6:26 pm, Pat wrote:
Incentive Credit Billed charge
($1.37) 4.6
$0.00 2.05
($0.05) 0.25
($1.42) $6.90 -4.85915493



  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat Pat is offline
external usenet poster
 
Posts: 210
Default 2 colums needs to sum and the anwsers needs to divide to get a pe



"Pat" wrote:

Incentive Credit Billed charge
($1.37) 4.6
$0.00 2.05
($0.05) 0.25
($1.42) $6.90 -4.85915493


I have two colums that i need to total and then i need to divide the two t
get a%
Reply
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
divide by zero arknsparc Excel Discussion (Misc queries) 1 April 22nd 09 08:15 PM
How to divide sheet in two or more sets of colums Joanne Excel Discussion (Misc queries) 3 April 19th 08 05:53 PM
divide by zero chiuinggum Excel Worksheet Functions 1 April 8th 06 09:52 AM
divide by 0 sony654 Excel Worksheet Functions 4 April 24th 05 08:10 AM
Divide one row over other row I dont wont to divide one number Rick Excel Discussion (Misc queries) 0 March 4th 05 07:13 PM


All times are GMT +1. The time now is 04:26 AM.

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

About Us

"It's about Microsoft Excel"