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, October 9, 2012
yogi_Compute Sum Of Amount For Each Entity From Table Of Entities and Amounts
Say I have a column (A3:A) that includes text like Cat, Dog, Turtle, etc. There's a value in another column (C3:C) for how much food that animal needs to eat. I want to sum up all of the cells that tell me how much all of the dogs each, or how much all of the cats eat, for example. The location of all instances of Cat are unknown. How do I sum up how much food they eat all together?