24*25=600the sum of 1 - 24 = 300
Aladin,=SUMPRODUCT(ROW(INDIRECT("1:"&A1)))
Aladin,=SUMPRODUCT(ROW(INDIRECT("1:"&A1)))
I get #REF
this works for me
=SUMPRODUCT(ROW(1:24))
using INDIRECT in SUMPRODUCT, is it possible ?
do I miss something ?
...
Cheers All yep they both work
now I can finish my calculator
little story for illustration
about 100 years ago, when Albert Einstein was 10-12 years old or less ...
Teacher (who wants to have some free-time to prepare the next lesson): Guys & gals, take a little sheet of paper, write down all numbers from 1 to 100 and calculate the sum
Little Albert, crossing his arms and looking to the sky for 5 seconds, takes his pencil and writes down the result. Ready!
1 + 100 = 101
2 + 99 = 101
3 + 98 = 101
...
50 + 51 = 101
hmm... 50 * 101 = 5050