• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum up four quarters in one cell

A

Amit Punia

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

What is needed in cell C9 is a formula which will automatically sum up all the four quarters in 2010(Jun2010-Sept2010-Dec2010-March2011 - The financial years starts from April and ends in March of next year). If we copy paste that formula in D9 it should show the sum up total of all quarters of 2011 and so on.
 

Attachments

  • Sum Up quarterly data in one cell.xlsx
    9 KB · Views: 11
The answer in C9 should come $ 6129.12

The question is not based on calender year. It is the financial year starting from April, 2010 and ends in March 2011. So for C9 the answer should be C2+D2+E2+F2.
 
@shrivallabha : Your answer is correct if it is for the calender year 2010, however I need the answer for financial year which starts from April 2010 and ends in March next year i.e. 2011.
 
@shrivallabha, Is it possible for you to provide a new formula to my problem. I need a formula in cell C9 which sum ups all the values from C2:F2. copy down and across gives me the same logic in other cells.

What is happening in the excel - Cell C9 contains all the addition of values in the 4 quarters of 2010-11(From April,2010 till March, 2011). In C8 I wrote 2011 because it's FY 2011 containing values of 2010.
 

Attachments

  • Sum Up quarterly data in one cell (2).xlsx
    9 KB · Views: 6
OK. In that case see if below works,
=SUMPRODUCT($C$2:$N$3*(((YEAR($C$1:$N$1)+(MONTH($C$1:$N$1)>3)=C$8)*($A$2:$A$3=$A9))))
 
You must log in or register to reply here.
Back
Top