Create a countifs function.

[vlmedia]

I would like to create a formula for each customer (column A; i.e. customer 1 made 8 purchases, customer 2 made 20 purchases, etc...) to calculate how many times they have bought a specific brand (column K; i.e. cell V8 shows that customer 1 bought 6 times brand 2). I have created a formula in column V but it won't work if I drag it down since I have 100 different customers.

 

[Marcelo Branco]

Maybe...

V2 copied down
=COUNTIFS(A$2:A2,A2,K$2:K2,K2)

M.

 

[vlmedia]

It worked. Thank you very much for your help!

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.