Harald Staff wrote...
If your goal is some kind of numeric calculation, not simple text,
then you can also use a technique similar to this:
=(A12500)+(A15000)+(A110000)+(A120000)+(A135 000)+(A150000)
+(A170000)+(A1100000)
....
You could, but why would you want to use it rather than
=SUMPRODUCT(--(A1{2500;5000;10000;20000;35000;50000;70000;10000 0}))
Any time you repeat the same cell reference more than 3 times the odds
become quite high that there's a more compact way to do what you're
trying to do.
|