Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i need a formula for two columns to sum and to be able divide the
Something like this :
=sum (T2:T4),(U2:U4)=(U5/T5) Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i need a formula for two columns to sum and to be able divide the
You tried to ask the question in the subject line, rather than in the body
of the message, so it's been truncated. Try to ask the question again, but this time in the body of the message so that we can see it. -- David Biddulph "Pat" wrote in message ... Something like this : =sum (T2:T4),(U2:U4)=(U5/T5) Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i need a formula for two columns to sum and to be able divide the
Didn't get the whole question, but if you want to say if the sum of T2
through T4 equals the sum of U2 through U4, then divide U5 by T5, then... =IF(SUM(T2:T4)=SUM(U2:U4),U5/T5,"") "Pat" wrote: Something like this : =sum (T2:T4),(U2:U4)=(U5/T5) Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i need a formula for two columns to sum and to be able divide
hello let me copy and paste the sample
Incentive Credit Billed charge -1.37 4.6 $0.00 2.05 ($0.05) 0.25 ($1.42) sum $6.90 sum -4.85915493 this is the answer i need I hope this is a better example thanks "Sean Timmons" wrote: Didn't get the whole question, but if you want to say if the sum of T2 through T4 equals the sum of U2 through U4, then divide U5 by T5, then... =IF(SUM(T2:T4)=SUM(U2:U4),U5/T5,"") "Pat" wrote: Something like this : =sum (T2:T4),(U2:U4)=(U5/T5) Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i need a formula for two columns to sum and to be able divide the
Hello, and thank for all you help I have column t2:t4 and u2:u4 i need to sum and then divide the answers between the two to get a percentage "Pat" wrote: Something like this : =sum (T2:T4),(U2:U4)=(U5/T5) Thanks |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i need a formula for two columns to sum and to be able divide
Try
=SUM(B:B)/SUM(A:A) If this post helps click Yes --------------- Jacob Skaria "Pat" wrote: hello let me copy and paste the sample Incentive Credit Billed charge -1.37 4.6 $0.00 2.05 ($0.05) 0.25 ($1.42) sum $6.90 sum -4.85915493 this is the answer i need I hope this is a better example thanks "Sean Timmons" wrote: Didn't get the whole question, but if you want to say if the sum of T2 through T4 equals the sum of U2 through U4, then divide U5 by T5, then... =IF(SUM(T2:T4)=SUM(U2:U4),U5/T5,"") "Pat" wrote: Something like this : =sum (T2:T4),(U2:U4)=(U5/T5) Thanks |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
i need a formula for two columns to sum and to be able divide the
Perhaps you want =SUM(U2:U4)/SUM(T2:T4) and format as percentage ?
-- David Biddulph "Pat" wrote in message ... Hello, and thank for all you help I have column t2:t4 and u2:u4 i need to sum and then divide the answers between the two to get a percentage "Pat" wrote: Something like this : =sum (T2:T4),(U2:U4)=(U5/T5) Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP! Need to divide all columns by same number to get sell price | Excel Worksheet Functions | |||
Autosum data from 2 columns with Divide function | Excel Discussion (Misc queries) | |||
DIVIDE FORMULA | Excel Discussion (Misc queries) | |||
Divide date into separate columns | Excel Worksheet Functions | |||
Divide one row over other row I dont wont to divide one number | Excel Discussion (Misc queries) |