Google Spreadsheet Solution With Advanced Query Formula

Question:

( by ANTONINO L )

Who can help me to solve this problem: 

I would like to sum ​​the number of packages in a column having a specific code for each month. 

How can I do?

Thanks

SHEET1				SHEET 2
DATI				SUMMARY
COD	DATA	Q.TA'		COD	DESCR	Q.TA' GEN	Q.TA' FEB	Q.TA' MAR
64	01/03/2014	5		64	PROD1			5
2227	13/02/2014	4		2227	PROD2		10	5
2227	11/03/2014	5		3339	PROD3
3456	09/01/2014	13		3456	PROD4	13
2227	27/02/2014	6

Solution:

Screenshot of Sheet1:

Screenshot of Sheet2:

I have the following formula in Cell A1 of Sheet2:

=query(arrayformula(iferror(if({1,1,1,0},Sheet1!A:C,if(Sheet1!B:B="","","Q.TA' "&text(Sheet1!B:B,"MM MMM"))))),"select Col1,sum(Col3) where Col1 is not null group by Col1 pivot Col4")

I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.

I also take up private and confidential projects:

http://igoogledrive.blogspot.com/p/paid-projects.html

If this blog post was helpful to you, and if you think you want to help me too and make my this blog survive then please donate here: http://igoogledrive.blogspot.com/2012/09/donate.html 

Thanks,

Kishan.

iGoogleDrive