Thread: condense formula that sums 4 adjacent columns
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
stevec stevec is offline
external usenet poster
  
Posts: 177
Default condense formula that sums 4 adjacent columns
Any suggestions on how to make this shorter?

=INDEX(OFA!$DM$4:$DM$6000,MATCH(A2,OFA!$D$4:$D$600 0,0),1)+INDEX(OFA!$DN$4:$DN$6000,MATCH(A2,OFA!$D$4 :$D$6000,0),1)+INDEX(OFA!$DO$4:$DO$6000,MATCH(A2,O FA!$D$4:$D$6000,0),1)+INDEX(OFA!$DP$4:$DP$6000,MAT CH(A2,OFA!$D$4:$D$6000,0),1)

many thanks!

SteveC


Reply With QuoteReply With Quote