View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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