tag:blogger.com,1999:blog-8807805591547673516.post346748093615123485..comments2024-02-28T08:14:50.756-08:00Comments on Cloud Computing -- Google Docs Way: yogi_Sum Up An Item In A Column To Fulfill Multiple CriteriaYogi Anandhttp://www.blogger.com/profile/10862524957172908621noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-8807805591547673516.post-22561064837465915562012-03-12T08:44:32.702-07:002012-03-12T08:44:32.702-07:00Hi Sandy:
instead of using:
=query("sheetB&q...Hi Sandy:<br /><br />instead of using:<br />=query("sheetB"!A:D,"select "sheetB!A:A",sum("sheetB"!D:D)group by "SheetB"!A:A)<br /><br />use:<br />=query(sheetB!A:D,"select A,sum(D)group by A")<br /><br />Cheers!<br />YogiYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-55094863114731462682012-03-12T04:38:00.701-07:002012-03-12T04:38:00.701-07:00Dear Yogi,
Would need your help again if it's...Dear Yogi,<br /><br />Would need your help again if it's not too much to ask.<br />I am trying to use above function in Sheet A but extracting the data from sheet B.<br />When I use the above function in sheet B itself, it works fine. But When i try to use below, it kept prompt me "Parse error"<br /><br />=query("sheetB"!A:D,"select "sheetB!A:A",sum("sheetB"!D:D)group by "SheetB"!A:A)<br /><br />I have tried the =sumif("sheetB"!A:A,"C0001","sheetB"!D:D)but it's either 'parse error' or it comes with wrong figure. Example, C0001 should have "2" count, but it came back as "0" instead.<br /><br />Example: <br />Sheet B<br />Employee Code Date Expiry Date No of Day Reason<br />C0001 XX/XX/XXXX XX/XX/XXXX 1<br />S0002 XX/XX/XXXX XX/XX/XXXX 0.5<br />J0003 XX/XX/XXXX XX/XX/XXXX 1<br />J0003 XX/XX/XXXX XX/XX/XXXX 1<br />C0001 XX/XX/XXXX XX/XX/XXXX 1<br /><br />Thank in advanced!Sandyhttps://www.blogger.com/profile/01032946592879029818noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-35708220596119451282012-03-08T13:01:27.611-08:002012-03-08T13:01:27.611-08:00Hi Sandy:
I am glad the solution works well for y...Hi Sandy:<br /><br />I am glad the solution works well for you ... Now Let Us Keep Googling.<br /><br />Cheers!<br />YogiYogi Anandhttps://www.blogger.com/profile/10862524957172908621noreply@blogger.comtag:blogger.com,1999:blog-8807805591547673516.post-77960453260606032262012-03-08T00:14:59.559-08:002012-03-08T00:14:59.559-08:00Hi,
Thank you so much. This is much easier without...Hi,<br />Thank you so much. This is much easier without having to create a separate record and it auto generates. It works very well.Sandyhttps://www.blogger.com/profile/01032946592879029818noreply@blogger.com