View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curt D.
 
Posts: n/a
Default Count if two columns match different criteria

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.