Forum Discussion
thebeachfarmer
May 30, 2024Copper Contributor
Equation Question
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, o...
SergeiBaklan
May 30, 2024Diamond Contributor
If that's one time operation, copy the cell with the formula into another cell, stay on that cell, Ctrl+H, Replace K on L