ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   2 colums needs to sum and the anwsers needs to divide to get a pe (https://www.excelbanter.com/excel-worksheet-functions/245258-2-colums-needs-sum-anwsers-needs-divide-get-pe.html)

Pat

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


Pete_UK

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



Pat

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




Pat

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%


All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com