I have numbers ranging from A2 to B29 that I want to multiply which one and the other (A2 should multiply with the number in A3, A3 with A4 etc.), but how do I do this on Calc? I change the numbers every now and then, and sometimes I use less cells than on other days…
Example: I have 4 numbers in place: 30, 40, 33 and 19. I could manually multiply them, yes, which would give me total number of 752400, but how do i make Calc do this automatically for me, even when i change the numbers in those cells, that are on different columns?
I hope this made somewhat sense… Sorry for my bad explaining…