ExcelBanter - View Single Post - Count if two columns match different criteria

Thanks Ardus that helps a lot.

"Ardus Petus" wrote:

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

Cheers,
--
AP

"Curt D." a écrit dans le message de news:
...
That did the trick. thanks. Is there a way to count the non-blank cells
instead of LAX?

"Ardus Petus" wrote:

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

HTH
--
AP

"Curt D." a écrit dans le message de
news:
...
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.