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.
Wednesday, February 20, 2013
yogi_Solution For Multiple SUMIF Type Conditions In A Google Spreadsheet
Google Spreadsheet Post #1038
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Feb 20, 2013 user CathB said:(http://productforums.google.com/forum/?zx=icnslbsw6sms#!searchin/docs/CathB/docs/K8EJ8wDXO_4/E39l5nodgjkJ)
Basically I want to add up all the hours spent by each type of group on each type of activity. Sumif won't do it for me; I've tried mucking about with sumproduct and arrays but frankly my brain isn't up to it. Can you help?