sum of numbers behind a specific letter

[IvoOvermars]

Hi,

It's been a while since I did anything with excel and VBA so I am a bit rusty.

I have sheet with data in wich the value always consists of two digits. The first is always a letter (V, Z, T, S) and the second is always a number ranging from 1 to 9. So cells are filled with V1, T6, V4, S9 etcetc. On a different sheet I would like the sum of all numbers behind V, the sum of all numbers behind S etcetc. I know I have build a similar thing years ago but I can't find that file :s and I can't figure out how I did this back then. Can anyone help me or point me in the right direction?

Kind regards,

Ivo

 

[Scott Huish]

Try this:

=SUM(IF(LEFT(Sheet1!A1:A1000)="T",RIGHT(Sheet1!A1:A1000)+0))

Confirm with CTRL-SHIFT-ENTER rather than just Enter.

Substitute the "T" with your other letters for the other formulas.