Sum up four quarters in one cell

[Amit Punia]

Kindly find the attached file. In the file there are variables called "Other Income" & "Income from Operations". Cell C1 till K1 contains quarters(four quarters for each year) and C2:K3 contains amount.

What is needed in cell C9 is a formula which will automatically sum up all the four quarters in 2010. If we copy paste that formula in C10 it should show the sum up total of all quarters of 2011 and so on.

 

[NARAYANK991]

Hi ,

Try this :

=SUM(OFFSET($C$2,MATCH($A9,$A$2:$A$3,0)-1,MATCH(C$8,$C$1:$K$1,0)-1,,4))

Narayan

 

[Amit Punia]

Thanx a lot Narayank for your help, the formula is working absolutely fine.

Thanx a ton!