With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Tuesday, January 1, 2013
yogi_Sum Number Of Shipped Items By Matching Date In Columns B And K And Location Shipped In Columns E And L
Google Spreadsheet Post #949
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Jan 01, 2013 user joao carvalho said:(http://productforums.google.com/forum/?zx=ljjtokot5b7x#!mydiscussions/docs/DIglgdAmhtM) Hi,
I'm not sure why I cannot apply a sumproduct function correctly, I was looking through several posts and I got stuck and with brain damage i think :)
I did a trial spreadsheet which might help to understand where I'm struggling with, the example is a replica of the real situation, basically I'm trying to automate a spreadsheet to retrieve results from a source data "sheet" in use by several different users, they tipe information in, and the sheet generates stats and further analyses.