Friday, April 25, 2014

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

SHEET1SHEET 2
DATISUMMARY
CODDATAQ.TA'CODDESCRQ.TA' GENQ.TA' FEBQ.TA' MAR
6401/03/2014564PROD15
222713/02/201442227PROD2105
222711/03/201453339PROD3
345609/01/2014133456PROD413
222727/02/20146


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,

No comments:

Post a Comment