I've tried to search for an answer to this but don't quite know how to phrase it...
I have a number of columns (1-31...looks suspiciously like a month) and want to sum a range of those columns depending upon two input cells.
So, to sum the 10th to the 18th columns I would like to be able to input the numbers 10 and 18 to drive the result.
I would prefer not to use VBA.
Any ideas? I'm sure it's easy???
Thanks
I have a number of columns (1-31...looks suspiciously like a month) and want to sum a range of those columns depending upon two input cells.
So, to sum the 10th to the 18th columns I would like to be able to input the numbers 10 and 18 to drive the result.
I would prefer not to use VBA.
Any ideas? I'm sure it's easy???
Thanks