Count IF Multipile Formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Can' use COUNTIF

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

to sum use

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