Posted to microsoft.public.excel.worksheet.functions
|
|
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.
|