| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countin and updating numbric and text
Try:
=COUNTIF(B3:Z3,"y") Tom "Anvil22" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countin and updating numbric and text
Tom,
that counts and replaces the number in a3, but doesn't update the number in a3. for example if a3 starts with 5 and there are two "y" cells in b3:z3, a3 shou updat to 7. I am really stumped. Dick "tompl" wrote: Try: =COUNTIF(B3:Z3,"y") Tom "Anvil22" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countin and updating numbric and text
I don't understand where the 5 comes from. What does it represent? How did
it get there in the first place? Tom |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countin and updating numbric and text
It starts as a beginnin number representing the number yo years they have participated in hte program. so if the participated in 2009 but not 2008 the 5 in b3 would update to 6. Dick "tompl" wrote: I don't understand where the 5 comes from. What does it represent? How did it get there in the first place? Tom |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countin and updating numbric and text
Not sure I fully understand but if the 5 is an entered amount you could just
add it in the formula and everything should work fine. =COUNTIF(B3:Z3,"y") + 5 Tom |
| Reply |
| 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 | |||
Hybrid Mode
