Count IF Multipile Formulas

[andreah]

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

 

[Bob Phillips]

Can' use COUNTIF

=SUMPRODUCT(--(A2:A100="value1"),--(B2:B100=17))

to sum use

=SUMPRODUCT(--(A2:A100="value1"),--(B2:B100=17),C2:C100)

 

[Don Guillett]

try where col b is people
=sumproduct((a2:a22={"airline1","airline2"})*(b2:b22))