Hello
Now I have the following:
=SUM(INDIRECT("P"&$G$3):INDIRECT("P"&$H$4))
In column P I have a set of data and in G3 and H4 i have certain numbers (for example 19 and 300) that i can switch, so I can choose from what, to what part I want to sum (for example SUM(P19:P300) ). Now I want to be able to drag this forumula to Q, R, S, T etc, just draging it wont do it since P here is locked, putting P on the outside didnt work since Indirect want a reference to a cell, also tried to make a row with P, Q R S T etc but I can't drag that, would I be able to do so that would also solve the problem since I then could refer to those cells in the indirect function.
Thankfull for any help
Regards Alexander
Bookmarks