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

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

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

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

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

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

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