## Friday, April 25, 2014

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:
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,