Hi,

Does this give the result you want?
=SUMIF(SZ:SZ,"option 1",H:H)
If yes and you want to summarise for all 31 text options, you might want to consider using a pivot table which will quickly give a sum of column H for each different value in column SZ.