Formula

[Yvette]

is there a way to have cells with numbers and letters and
have the system total them in another cell?

TOTAL UFL
Example 3UFL 4UFL 7

 

[Jason Morin]

In your specific case, try:

=SUMPRODUCT(1*(LEFT(A1:B1,SEARCH("U",A1:B1)-1)))

HTH
Jason
Atlanta, GA