I need to update a number cell from a text filed.
Cell a3 represent the total years of participation. Cellsb3,d3,e3 ECT
represent the current year of activity by a €œy€�.
I am trying to update the number in a3 €“ 5- to 6 or 7 or 8 based on whether
or not there is a €œy€� in b3,d3,e3 ECT.
Example a3=5
B3- blank
C3 = €œy€� would update a3 to 6
D3 blank
E3 = €œy€� would update b3 to7
I have tried a number of count and countif and countifs and always receive
the value error because of the €œy€�
Can anyone help?
Thanks
Dick