Counting from one range to another range, multiple criteria

[macamarr]

I have 600 account # and 5 five weeks of deliveries. All the account numbers
are in column A and all the account # delivered are in column B. What I need
to do is count all the accounts delivered and place the count in column C. If
there is a way please inform. Thank You!


I am trying to avoid having to type/change the criteria in each lines formula.

[Bob Phillips]

Is it not just =COUNTIF(B:B,"<>")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"macamarr" <[email protected]> wrote in message
news:[email protected]...
> I have 600 account # and 5 five weeks of deliveries. All the account
numbers
> are in column A and all the account # delivered are in column B. What I
need
> to do is count all the accounts delivered and place the count in column C.
If
> there is a way please inform. Thank You!
>
>
> I am trying to avoid having to type/change the criteria in each lines
formula.

[macamarr]

No, that will not work. Here is how I have to formulate now
(=COUNTIF(A:A,"5")) The problem with that is I would have to do that for
every account number that recieved a delivery. I have 600 accounts that
possibly recieved a delivery(s) over the course of six weeks. I want to count
how many times they were delivered.

Example:
Deliveries Account# Count of Deliveries
"A" " B" "C"
1 1 2
2 2 2
2 3 0
52 4 0

71 5 0
71 6 0


further down the line 52 = 1 & 71 = 2




"Bob Phillips" wrote:

> Is it not just =COUNTIF(B:B,"<>")
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "macamarr" <[email protected]> wrote in message
> news:[email protected]...
> > I have 600 account # and 5 five weeks of deliveries. All the account
> numbers
> > are in column A and all the account # delivered are in column B. What I
> need
> > to do is count all the accounts delivered and place the count in column C.
> If
> > there is a way please inform. Thank You!
> >
> >
> > I am trying to avoid having to type/change the criteria in each lines
> formula.
>
>
>

[Bob Phillips]

can you not just add those account numbers to another sheet and use the cell
reference in the formula?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"macamarr" <[email protected]> wrote in message
news:[email protected]...
> No, that will not work. Here is how I have to formulate now
> (=COUNTIF(A:A,"5")) The problem with that is I would have to do that for
> every account number that recieved a delivery. I have 600 accounts that
> possibly recieved a delivery(s) over the course of six weeks. I want to
count
> how many times they were delivered.
>
> Example:
> Deliveries Account# Count of Deliveries
> "A" " B" "C"
> 1 1 2
> 2 2 2
> 2 3 0
> 52 4 0
>
> 71 5 0
> 71 6 0
>
>
> further down the line 52 = 1 & 71 = 2
>
>
>
>
> "Bob Phillips" wrote:
>
> > Is it not just =COUNTIF(B:B,"<>")
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "macamarr" <[email protected]> wrote in message
> > news:[email protected]...
> > > I have 600 account # and 5 five weeks of deliveries. All the account
> > numbers
> > > are in column A and all the account # delivered are in column B. What
I
> > need
> > > to do is count all the accounts delivered and place the count in
column C.
> > If
> > > there is a way please inform. Thank You!
> > >
> > >
> > > I am trying to avoid having to type/change the criteria in each lines
> > formula.
> >
> >
> >