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

 

[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