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
|