software

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.

=SUMPRODUCT((A1:A999=737)*(B1:B999=quot;LAXquot;))

HTH
--
AP

quot;Curt D.quot; gt; a écrit dans le message de news:
...
gt; How can I count two columns with different criterias. In one column if it
gt; contains 737 and if another column contains LAX, how can I count them if
gt; they
gt; only meet this criteria? Thanks for the help.
That did the trick. thanks. Is there a way to count the non-blank cells
instead of LAX?

quot;Ardus Petusquot; wrote:

gt; =SUMPRODUCT((A1:A999=737)*(B1:B999=quot;LAXquot;))
gt;
gt; HTH
gt; --
gt; AP
gt;
gt; quot;Curt D.quot; gt; a écrit dans le message de news:
gt; ...
gt; gt; How can I count two columns with different criterias. In one column if it
gt; gt; contains 737 and if another column contains LAX, how can I count them if
gt; gt; they
gt; gt; only meet this criteria? Thanks for the help.
gt;
gt;
gt;

=SUMPRODUCT((A1:A999=737)*(B1:B999lt;gt;quot;quot;))

Cheers,
--
AP

quot;Curt D.quot; gt; a écrit dans le message de news:
...
gt; That did the trick. thanks. Is there a way to count the non-blank cells
gt; instead of LAX?
gt;
gt; quot;Ardus Petusquot; wrote:
gt;
gt;gt; =SUMPRODUCT((A1:A999=737)*(B1:B999=quot;LAXquot;))
gt;gt;
gt;gt; HTH
gt;gt; --
gt;gt; AP
gt;gt;
gt;gt; quot;Curt D.quot; gt; a écrit dans le message de
gt;gt; news:
gt;gt; ...
gt;gt; gt; How can I count two columns with different criterias. In one column if
gt;gt; gt; it
gt;gt; gt; contains 737 and if another column contains LAX, how can I count them
gt;gt; gt; if
gt;gt; gt; they
gt;gt; gt; only meet this criteria? Thanks for the help.
gt;gt;
gt;gt;
gt;gt;
Thanks Ardus that helps a lot.

quot;Ardus Petusquot; wrote:

gt; =SUMPRODUCT((A1:A999=737)*(B1:B999lt;gt;quot;quot;))
gt;
gt; Cheers,
gt; --
gt; AP
gt;
gt; quot;Curt D.quot; gt; a écrit dans le message de news:
gt; ...
gt; gt; That did the trick. thanks. Is there a way to count the non-blank cells
gt; gt; instead of LAX?
gt; gt;
gt; gt; quot;Ardus Petusquot; wrote:
gt; gt;
gt; gt;gt; =SUMPRODUCT((A1:A999=737)*(B1:B999=quot;LAXquot;))
gt; gt;gt;
gt; gt;gt; HTH
gt; gt;gt; --
gt; gt;gt; AP
gt; gt;gt;
gt; gt;gt; quot;Curt D.quot; gt; a écrit dans le message de
gt; gt;gt; news:
gt; gt;gt; ...
gt; gt;gt; gt; How can I count two columns with different criterias. In one column if
gt; gt;gt; gt; it
gt; gt;gt; gt; contains 737 and if another column contains LAX, how can I count them
gt; gt;gt; gt; if
gt; gt;gt; gt; they
gt; gt;gt; gt; only meet this criteria? Thanks for the help.
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;