Counting the Same Rows

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
>