The following is a formula that I have in my spreadsheet:

=-SUM(SUMIF(INDIRECT({“k2″,”k7″,”k11″,”k15″,”k19″,”k23″,”k27″,”k31″,”k35″,”k39″,”k43″,”k47″,”k51″,”k55″}),”>0″))

I would like to drag, or copy the formula to column L and have all references to column K change to column L.  What is the easiest way to do this.  I’m currently using Word and doing a search and replace for K and changing to L.

Thanks in advance…John

​The following is a formula that I have in my spreadsheet:=-SUM(SUMIF(INDIRECT({“k2″,”k7″,”k11″,”k15″,”k19″,”k23″,”k27″,”k31″,”k35″,”k39″,”k43″,”k47″,”k51″,”k55″}),”>0″)) I would like to drag, or copy the formula to column L and have all references to column K change to column L.  What is the easiest way to do this.  I’m currently using Word and doing a search and replace for K and changing to L. Thanks in advance…John  Read More

​