i need a formula for two columns to sum and to be able divide the

[Pat]

Something like this :
=sum (T2:T4),(U2:U4)=(U5/T5)

Thanks

 

[LauraM]

Something like this :
=sum (T2:T4),(U2:U4)=(U5/T5)

Thanks

Try this:
=(sum(U2:U4))/(sum(T2:T4)

If T is negative or a 0 value, you will need an if statement:
=if((sum(T2:T4))>0,(sum(U2:U4))/(sum(T2:T4),"VALUE IF FALSE",0)

You choose what the value should be the sum of T2:T4 is less than or
equal to 0.

ETA: After rereading your original message, I think I misunderstood.
Can you clarify a bit more for me???

 

[David Biddulph]

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.

 

[Sean Timmons]

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]

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

 

[Pat]

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

 

[Jacob Skaria]

Try
=SUM(B:B)/SUM(A:A)

If this post helps click Yes

 

[David Biddulph]

Perhaps you want =SUM(U2:U4)/SUM(T2:T4) and format as percentage ?