G
Guest
this is what i have now:
=INDEX(EBITDA!$L$13:$L$6000,MATCH(D13,EBITDA!$D$13:$D$6000,0),1)+INDEX(EBITDA!$M$13:$M$6000,MATCH(D13,EBITDA!$D$13:$D$6000,0),1)+INDEX(EBITDA!$N$13:$N$6000,MATCH(D13,EBITDA!$D$13:$D$6000,0),1)+INDEX(EBITDA!$O$13:$O$6000,MATCH(D13,EBITDA!$D$13:$D$6000,0),1)
you see this formula is on one worksheet, matching numbers on another
worksheet to sume together 4 columns. This looks ugly. Is there a smaller
way of doing this -- to at least add together columns m, n and o all at once?
thanks for taking a look...
=INDEX(EBITDA!$L$13:$L$6000,MATCH(D13,EBITDA!$D$13:$D$6000,0),1)+INDEX(EBITDA!$M$13:$M$6000,MATCH(D13,EBITDA!$D$13:$D$6000,0),1)+INDEX(EBITDA!$N$13:$N$6000,MATCH(D13,EBITDA!$D$13:$D$6000,0),1)+INDEX(EBITDA!$O$13:$O$6000,MATCH(D13,EBITDA!$D$13:$D$6000,0),1)
you see this formula is on one worksheet, matching numbers on another
worksheet to sume together 4 columns. This looks ugly. Is there a smaller
way of doing this -- to at least add together columns m, n and o all at once?
thanks for taking a look...