Formula

  • Thread starter Thread starter Yvette
  • Start date Start date
Y

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
 
In your specific case, try:

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

HTH
Jason
Atlanta, GA
 
Back
Top