P
Pat
Something like this :
=sum (T2:T4),(U2:U4)=(U5/T5)
Thanks
=sum (T2:T4),(U2:U4)=(U5/T5)
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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,"")
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
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
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
J
Jacob Skaria
Try
=SUM(B:B)/SUM(A:A)
If this post helps click Yes
=SUM(B:B)/SUM(A:A)
If this post helps click Yes