COUNTIF formula

[xochi99]

Excel n00b needs formula help...

I'm trying to set a formula that will count values...something like this;

If any cell in g4:g439 = "location" & any cell h4:h439 = "team" then count as 1

Certain locations have more than 1 team and some teams are in more than 1 location...so i need to count all the combinations independantly. When I try to put in more than 1 cell range I get an error. bleh...i give up!

[mikerickson]

=SUMPRODUCT(-(G4:G439="location),-(H4:H439="team"))