Sum of Particular product in particular month

[Kutty]

Hai Friends!
I want to sum the particular product in particular month. Please suggest one of the excel formula.

 

[vletm]

Could You use Pivot-table, then no need formulas?

 

[Kutty]

Could You use Pivot-table, then no need formulas?

Sry. I don't want pivot table.

 

[shrivallabha]

SUMPRODUCT function can help you in this. Refer this blog post:
http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/

 

[Kutty]

I expect this type of formula with particular product
https://stackoverflow.com/questions/15285381/excel-formula-to-sumif-date-falls-in-particular-month

 

[shrivallabha]

I expect this type of formula with particular product
https://stackoverflow.com/questions/15285381/excel-formula-to-sumif-date-falls-in-particular-month

Why expect when you can also try yourself . BTW, SUMPRODUCT is also listed at the end of the post.

You have to upload workbook (not image) so that others can respond to it directly rather than rebuilding the structure themselves!

 

[Haseeb A]

Hello Kutty,

Take a look on SUMIFS formula,

In G2:L2 enter first day in each month & format as "mmm-yy, then G3, copy down & across.

=SUMIFS($B:$B,$A:$A,">="&G$2,$A:$A,"<="&EOMONTH(G$2,0),$C:$C,$F3)

 

[rahulshewale1]

Hii..
Please find the attach file


Thanks
Rahul Shewale

 

[Kutty]

Hii..
Please find the attach file


Thanks
Rahul Shewale

Thanks @Rahul Shewale
It's useful to me. Now my doubt is cleared.

 

[Kutty]

Thanks @haseeb Avarakkan