| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
countin and updating numbric and text
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Updating Split Text field | Excel Discussion (Misc queries) | |||
| Countin Numbers in a Workbook | Excel Discussion (Misc queries) | |||
| Automatic updating for text boxes used on Charts | Excel Discussion (Misc queries) | |||
| Countin Dates | Excel Worksheet Functions | |||
| Adding cells with alphabet and returning a numbric value | Excel Worksheet Functions | |||
Threaded Mode
