Tuesday, October 9, 2012

yogi_Compute Sum Of Amount For Each Entity From Table Of Entities and Amounts

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #797  Oct 09, 2012    www.energyefficientbuild.com.

user JohnPraw said: (http://productforums.google.com/forum/?zx=ygk1rp8l5d3#!searchin/docs/dog/docs/TZbchRB7TWU/aswCjJwQimkJ)
Calculating the sum of a column with specific text in a corresponding column in the same row.

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?

following is a solution to the problem