Skip,
the only things in the row after the total column are the values I want to sum. I don't know whether using FormulaR1C1 syntax might be better?
Thx
- Julie
I'm writing an Excel app that inserts columns as required and then sums them. At the moment I've got a template with the first column as the sum and then the second column as the iterating column - I copy it and paste one column to the right as required. I've got a SUM(Col2:Colx) in Column1...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.