Thread
:
Count if two columns match different criteria
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
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.
Reply With Quote