Referring to a cell with integers

[farkasmate]

Dear All,

I have an Excel-sheet with monthly sales values from 01-2011 to 12-2020.
I want to summarize them quarterly, and I want a macro that does it automatically by jumping to the next 3 month's sales data every time.
The only thing that is not clear to me is where to put the apostrophes when referring to a cell with integers and I want to summarize the values...
Here's what I have (I previously defined i, j and k):

Please Login or Register  to view this content.

Could you please help me? When I use Range.Select function it works with the apostrophes above, but with the SUM function it does not.
Thanks in advance.

[rorya]

You don't use quotes within the formula, so:

Please Login or Register  to view this content.

[farkasmate]

Thanks Rory for your quick reply

Now it seems working.