i need a formula for two columns to sum and to be able divide the
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
|