View Single Post
  #1   Report Post  
cbarcroft
 
Posts: n/a
Default How do I add row total when cell contains both number and letter .

I have a timesheet spreadsheet. Cell contents include hours and coding.
Example: 8 (8 hours regular pay-no letter) or 8V (8 hours vacation pay). I
want to have a total at the end but my formula will only read the cells that
don't have a letter after the number.