• 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.

Formula to get amount adding according by month

VRIndranee

New Member
Hi All,

Attached is my excel picture A and B.

From picture A data, i need a formula to add amount according by month ex: Jan and the result to appear in cell C9, picture B.

Please advise.

Thank you.

Regards,
VIndranee
 

Attachments

bosco_yip

Excel Ninja
1] Remove all trailing space after the wording of "stationery" in "Data List sheet"

2] In "overall" sheet C8, copied across and down :
=SUMIFS('Data List'!$G:$G,'Data List'!$H:$H,MONTH(C$5&1),'Data List'!$C:$C,$B8)

Regards
Bosco
 

Attachments

Peter Bartholomew

Well-Known Member
This is the same formula but based upon input data held as a table and is a dynamic array version
= SUMIFS( DataTable[Amount], DataTable[Month], MONTH(mnth&1), DataTable[Description], Description )
The formula is entered into cell Overall!C8 and spills to populate the output range.
 

Juniad

Member
Excel is Fun. try this one also
Copy the formula and paste in Overall sheet cell C8 and drag over and down.
=SUMPRODUCT(('Data List'!$C$4:$C$17=$B8)*(('Data List'!$F$4:$F$17)>=C$5)*(('Data List'!$F$4:$F$17)<=EOMONTH(C$5,0))*'Data List'!$G$4:$G$17)
 
Top