Sunday, July 22, 2012

yogi_Summarize Columnar Data And Present It In Pivot Table Like Format

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #646   Jul 22, 2012     www.energyefficientbuild.com.


user jaegeetee said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/kkhvRHP2K9c)
How would I count if conditions are met in the same row but different column?
I have a dataset that counts what was ordered at a coffee shop by men vs women.  How would I count how many times a man ordered a latte
----
it would be something like this (obviously its in cells in a google spreadsheet):
Gender          Drink  
Male            latte
Female          Coffee
Male            Frappuccino
Female          Latte
Male            Latte
Male            Coffee
I was wanting to count the amount of Males that ordered the various drinks.  So my goal was to have another section on the spread sheet would look like this:
                 Male           Female
Coffee            1               1
latte             2               1
frappuccino       1               0
--------------------------------------------------------------------------------------------------
following is one solution to the problem