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

L

LauraM

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

Thanks
Click to expand...

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???
 
D

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.
 
S

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,"")
 
P

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
 
P

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
 
Top