Adding cells which are in periodic

[sruthi94]

Hi all,
I have to add the column cell which are in periodic.Suppose what if I want to ADD cells C1+C2+C3 and in other cell C4+C5+C6 and in other cell C7+C8+C9 and so on. Is there any formula for this.Kindly help me with this.

[Pete_UK]

There are a number of ways that you could do this, though it is not very clear how your data is laid out. Which cells do you want the formula in? It might be clearer if you attach a sample workbook - the FAQ describes how to.

Pete