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

=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.