Man of Honour
Need a bit of help with a formula but I could be asking too much.
In the cells going down are model numbers
A1 = EW73
A2 = EW93
A3 = EDCH35H
A4 = X157G
A5 =
A6 =
A7 =
A8 =
A9 =
A10 = Total
What I want to be able to do is when I write a model number in it adds '1' to the total in A10. Looking at the above A10 should be reading 4 and if I add another model number into A5 then A10 will read 5.
Any ideas?
In the cells going down are model numbers
A1 = EW73
A2 = EW93
A3 = EDCH35H
A4 = X157G
A5 =
A6 =
A7 =
A8 =
A9 =
A10 = Total
What I want to be able to do is when I write a model number in it adds '1' to the total in A10. Looking at the above A10 should be reading 4 and if I add another model number into A5 then A10 will read 5.
Any ideas?