Re: Array Function

=COUNTIF(B1:B100,"xxx")

assuming B1:B100 is the right column.

--
HTH

Bob Phillips

"Egon" <jhalljr@xxxxxxxxx> wrote in message
news:1121693663.756895.131280@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I'm having a mess of a time getting this to work.
>
> I have an array from a report. I need to count the people in the left
> column who have a certain value in the right column. I'm doing
> something wrong, or its monday morning and I can't seem to get it to
> work.
>
> Can anyone help me out here?
>
> J.
>


.

Relevant Pages

  • Re: Conditional formating, values.
    ... The trick is to ensure that that is the first condition, ... > HTH ... > Bob Phillips ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Totaling Months
    ... HTH ... Bob Phillips ... > I have 3 columns in my worksheet, column F Date Due, column G is Date ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: excel sorting task
    ... HTH ... Bob Phillips ... > I have the following data in a worksheet ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: How do I make a column of checkboxes quickly?
    ... HTH ... Bob Phillips ... > I have a list of people my company has already mailed letters to (about ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: nested formula with if condotion
    ... HTH ... Bob Phillips ... > can anybody helpme out to put formula using if or any other ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)