Creating a ifs function - spill error

[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 a ratio in column W based on column V. For example, cell W5 should return 0.75 (3 divided by 4; 3 comes from cell V5 and 4 comes from 4 observations including V5), cell W6 should return 0.80 (4 divided by 5), etc...

I tried this formula "=IF($A2=1,V2/COUNT(V2))" but won't work if I drag it down since I have 100 different customers.
I attempted a different formula "=IF(A$2:A2=A2,V2/(COUNT(V$2:V2)))" but I get a spill error.

Thank you in advance for your help.

 

[Eric W]

Try in W2:

=V2/COUNTIF($A$2:$A2,A2)

I haven't actually tested this since I didn't want to type in all your data, but it should work.

 

[vlmedia]

It worked perfect. Thank you very much!

 

[Eric W]

Happy to help!