Formula to get amount adding according by month

[VRIndranee]

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

 

[vletm]

VRIndranee
Your Please advise...
Upload a sample EXCEL-file which has those datas from Your sent pictures..

 

[VRIndranee]

Hi,

Please find attached excel file.

 

[herofox]

here you are

 

[bosco_yip]

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

 

[Peter Bartholomew]

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.

 

[VRIndranee]

Thank you everyone for the wonderful formula.

 

[Juniad]

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)