Wildcard in formula

[irenesboy]

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

 

[yee388]

=IF(LEN(A1)=4,B1+C1,"")

Where A1 has the team abbreviation, B1 & C1 have team scores.

Helpful?

 

[texasalynn]

Yes sometimes describing the problem is difficult. That's where using the Colo utility found at the bottom of this page allows you to make a picture sample of what you have and what you want.

So could you post a small sample?

 

[irenesboy]

Hi yee 388
It sure is simple when you know how.
Thanks a lot works like I wanted it to.
irenesboy