Re: count problem

From: "KL" <NOSPAMlapink2000@xxxxxxxxxxxxxxxxx>
Date: Wed, 27 Jul 2005 23:26:24 +0200

Hi vipa,

Try this:

=COUNT($A$2:$A$6)-COUNTIF($D$2:$D$6,"HUD*")

Regards,
KL

"vipa2000" <vipa2000@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4C1619BC-76CB-4A14-A4A7-D96D725B07A9@xxxxxxxxxxxxxxxx
>I am trying to setup a spread*** where data will be imported in from
> another package into a *** within the spread*** on a monthly basis. On
> another *** I am trying to setup various formula that will analyse this
> data automatically. Normally i would use Access but other people within
> the
> company do not understand Access. The issue:-
>
> I can't get the count function or any derivative to do what i want.
> Example
> of problem below.
> A b c d
> e
> 120873 50183368 6 blank REL NMAT PRC SETC
> 120873 50183299 4 blank CLSD PRT NMAT PRC
> 122873 50185108 3 blank PCNF NMAT PRC SETC
> 122873 50178522 3 HUDS002277 TECO PCNF PRT NMAT
> 122873 50147658 5 HUDS003115 REL NMAT PRC SETC
>
> I want to total the no of records in column A but deduct those records in
> column d where a record is found with a hud prefix
>
> --
> Regards vipa

.

Follow-Ups:
- Re: count problem
  - From: Sandy Mann
- Re: count problem
  - From: KL

References:
- count problem
  - From: vipa2000

Prev by Date: Convert rows into 1 cell or 1 string
Next by Date: How to use variable in reference
Previous by thread: count problem
Next by thread: Re: count problem
Index(es):
- Date
- Thread