Re: Array Function

On 18 Jul 2005 07:09:10 -0700, "Egon" <jhalljr@xxxxxxxxx> wrote:
>Maybe I didn't explain myself properly.
>
>I have a list of positions in the "A" Column and a list of companies in
>the "B" column. I need to get the number of positions in the "A" column
>who's company is equal to a certain company in the B column.
>
>CountIF seems to only count within a certain column.

Oops.. make that "SUM" instead of "COUNT" in my answer.

Sorry, waking.

MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner
.

Relevant Pages

  • Re: Array Function
    ... >CountIF seems to only count within a certain column. ... "Learning is a behavior that results from consequences." ... B.F. Skinner ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Excel book
    ... >Check out John Walkenbach's Excel 2003 Bible as a start. ... "Learning is a behavior that results from consequences." ... B.F. Skinner ... Prev by Date: ...
    (microsoft.public.excel.newusers)
  • Re: To our UK, Lebanese, & Egyptian brothers
    ... worth it. ... "Learning is a behavior that results from consequences." ... B.F. Skinner ... Prev by Date: ...
    (alt.marketing.online.ebay)
  • Re: Excel Formula
    ... >of different products from different suppliers. ... "Learning is a behavior that results from consequences." ... B.F. Skinner ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: death of the mind.
    ... >> indispensable reading after Science and Human Behavior, About Behaviorsm, ... Tonight I was browsing through an old Skinner ... >Theories of Learning Pretentious in their Aims?" ... I liked Skinner's remarks ...
    (sci.cognitive)