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):