Counting the Same Rows

S

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
 
B

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)
 
S

Steve M

I need to count every customer so I get

customer a = 3 transactions
customer b = 2 transactions

etc

if that makes sens
 
S

Steve M

I need to count every customer so I get

customer a = 3 transactions
customer b = 2 transactions

etc

if that makes sens
 
B

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)
 
Top