Monday, August 1, 2011

yogi_Calculate Average For Entries In A Column Based On Values In Another Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

nicomachus said:
How do I calculate the average of one column consistent with something from another column?
For example, let's say I have two columns. Possible entries in the first column are A, B, and C. The second column has numbers. I want to use the Average formula to find the average numerical value of all of the As. Then another for all of the Bs. Does that make sense?
--------------------------------------------------------------------