View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pat Pat is offline
external usenet poster
 
Posts: 210
Default 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