| 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countin and updating numbric and text
Tom,
The problem is that other rows referance other groups, and each have their own years of participation. Therefore the 5 isn't constant, the a3 column could be 5, 11, 15, 20. Which is why I have bee trying to find a cell formula that could be applied. Best, Dick "tompl" wrote: 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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countin and updating numbric and text
The years of participation is data that must be entered somewhere. You can
enter it in this formula differently for each line, or you can have another column in which to enter this number then add the value in the new column to this formula. For example, the years of participation number is entered into column B and your formula becomes =COUNTIF(C3:Z3,"y") +B3 Tom |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
countin and updating numbric and text
Tom,
That works with hiding the C column. I appreciate the time you took to help solve the proble, Dick "tompl" wrote: The years of participation is data that must be entered somewhere. You can enter it in this formula differently for each line, or you can have another column in which to enter this number then add the value in the new column to this formula. For example, the years of participation number is entered into column B and your formula becomes =COUNTIF(C3:Z3,"y") +B3 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 | |||
Linear Mode
