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

user jaegeetee said:(!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