Counting the Same Rows

I have a spreadsheet with 2 columns column a is CustomerID and Column B is TransactionDate

I need a way of counting how many transaction dates a customer as

column A can have the same customer ID in multiple times

Any help appreciated

Steve

Is it just

=COUNTIF(A:A,"Customer A")

or do you need to test the dates as well

=SUMPRODUCT(--(A2:A200="Customer A"),--(B2:B200<>""))

Note that SUMPRODUCT doesn't work with complete columns, you have to specify
a range.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steve M" <Steve.M.26k67y_1145529001.1023@excelforum-nospam.com> wrote in
message news:Steve.M.26k67y_1145529001.1023@excelforum-nospam.com...
>
> I have a spreadsheet with 2 columns column a is CustomerID and Column B
> is TransactionDate
>
> I need a way of counting how many transaction dates a customer as
>
> column A can have the same customer ID in multiple times
>
> Any help appreciated
>
> Steve
>
>
> --
> Steve M
> ------------------------------------------------------------------------
> Steve M's Profile:
http://www.excelforum.com/member.php...o&userid=32520
> View this thread: http://www.excelforum.com/showthread...hreadid=534495
>

I need to count every customer so I get

customer a = 3 transactions
customer b = 2 transactions

etc

if that makes sense

So list the customers in a separate range, M1:M10 say, and use

=COUNTIF(A:A,M1)

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Steve M" <Steve.M.26k82m_1145531400.9045@excelforum-nospam.com> wrote in
message news:Steve.M.26k82m_1145531400.9045@excelforum-nospam.com...
>
> I need to count every customer so I get
>
> customer a = 3 transactions
> customer b = 2 transactions
>
> etc
>
> if that makes sense
>
>
> --
> Steve M
> ------------------------------------------------------------------------
> Steve M's Profile:
http://www.excelforum.com/member.php...o&userid=32520
> View this thread: http://www.excelforum.com/showthread...hreadid=534495
>