Counting the Same Rows

[Steve M]

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

 

[Bob Phillips]

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]

I need to count every customer so I get

customer a = 3 transactions
customer b = 2 transactions

etc

if that makes sens

 

[Steve M]

I need to count every customer so I get

customer a = 3 transactions
customer b = 2 transactions

etc

if that makes sens

 

[Bob Phillips]

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)