Count if two columns match different criteria

[Guest]

How can I count two columns with different criterias. In one column if it
contains 737 and if another column contains LAX, how can I count them if they
only meet this criteria? Thanks for the help.

 

[Ardus Petus]

=SUMPRODUCT((A1:A999=737)*(B1:B999="LAX"))

HTH

 

[Guest]

That did the trick. thanks. Is there a way to count the non-blank cells
instead of LAX?

 

[Ardus Petus]

=SUMPRODUCT((A1:A999=737)*(B1:B999<>""))

Cheers,

 

[Guest]

Thanks Ardus that helps a lot.

=SUMPRODUCT((A1:A999=737)*(B1:B999<>""))

Cheers,