condense formula that sums 4 adjacent columns
Another one:
=SUM(INDEX(OFA!DM4:DP6000,MATCH(A2,OFA!D4:D6000,0) ,))
--
Biff
Microsoft Excel MVP
"SteveC" wrote in message
...
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
|