Hello Experts,

I have different status in the range for eg: A,B,C,D,E,F

Let say if the status is "A" in the range "B2", then a numeric value "1" should be added in corresponding row range "F2"

Similarly if the status is changed to "B" then numeric value should be "2"

Can anybody help me out a code for this?

Thanks in Advance.