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
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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks