I wanna ask you. I have value which I want divide and sum. I will give you example:
Which I want series sum
A1 Value 5 B1
A3 Count 4 B3
10,41666667 **B5**
=SUM(B1;B1/2;B1/3;B1/4)
I want when I change count value formula will calculate automaticaly as formula "=SUM(B1;B1/2;B1/3;B1/4)"
Count value continues up to n, formula should work even if count value 1000.
Please help. I hope so I could explain.
>Solution :
Try this formula
Formula used in cell B5
=SUM(B1/ROW(INDIRECT("1:"&$B$3)))
Or you can use SUMPRODUCT Function as well, to avoid the CTRL+SHIFT+ENTER
Formula used in cell D5
=SUMPRODUCT(D1/ROW(INDIRECT("1:"&$D$3)))
