How do I count occurrences of multiple values by using the Count If formula.
The help page stated that I could assisgn a value of 1 with IF functions but
I don't know how to do this. I have three columns, one with cost, one with
number of people and one with airline. I want to count the cost and the
number of people for each airline, and group some airlines together. E.g.
cost and number of people for airline 1 and airline two. Cost and number of
people for airline not specified. Any ideas? Thanks Andrea