I have a column of 3 letter team abbrevations (there are 32 teams)
In some of the cells there will be a fourth letter added (O or U).
In another cell in the same row (IF there is a fourth letter added O or U) I would like to add the two cells that hold the team team scores and insert the result in that cell.
I would like to be able to copy the formula down the column and have the cells that do not have a (fourth letter) result be blank.
I am not to good at writing what I would like to do so I hope somebody can understand my question.
I would appreciate any help.
irenesboy
In some of the cells there will be a fourth letter added (O or U).
In another cell in the same row (IF there is a fourth letter added O or U) I would like to add the two cells that hold the team team scores and insert the result in that cell.
I would like to be able to copy the formula down the column and have the cells that do not have a (fourth letter) result be blank.
I am not to good at writing what I would like to do so I hope somebody can understand my question.
I would appreciate any help.
irenesboy