Excel - calculation for 50 cells w/o VBA coding it
Posted on 2013-01-08
I wanted to see if there is a way to write an Excel Formula that will calculate a large set of numbers without having to type it all out. I am trying to avoid using VBA coding, if possible. But will resort to it if needed.
Range("C57") = sum("D6*$L$6)+(D7*$L$7) this continues to row 50. It is always column D * L.
Is there a way to write this as a function instead of typing 45 steps?
Otherwise I need to set it as a change cell event for range (D6:I50).
If I can be helped with both of these scenerios - it would be great.