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):
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
No comments:
Post a Comment