How to sum all the numbers where there is a letter together with the numbers in the cell?

Hi @Patrikas, I'm sure others would have other suggestions. If the format of the values in your hours column is always the number + one letter, one way you could do it is create another column and use a formula like the below to "trim off" the final character - then sum the values n that column.

=LEFT([Column name]@row, LEN([Column name]@row) - 1)

Let me know if that helps!

Hi @Patrikas, apologies, I don't fully understand your comment. Do you have a screenshot you can share with column names and some sample data? Thanks!

Hi @Patrikas, you could. Do the number of rows vary? I see from the screenshot, there are potentially 4 rows that could have data in them. Looking at Sep 3rd, I see N11, N12, S and a blank row under that.

Assuming it is 4 rows and your first row of data that you want to sum is row 5 (it looks like row 5), try this formula in row 13 (the first row after the two yellow and one blue rows):

=SUM(VALUE(MID([Column Name]5, 2, LEN([Column Name]5))), VALUE(MID([Column Name]6, 2, LEN([Column Name]6))), VALUE(MID([Column Name]7, 2, LEN([Column Name]7))), VALUE(MID([Column Name]8, 2, LEN([Column Name]8))))

I've changed it a little because it looks like the letter comes before the number but your original post has the letter coming after the number.