Guys please help,

Beginner to excel and have a tricky one...

Column A contains only I, II, III, IV and V, but this repeats (example, A1=I, A2=III, A3=IV, A4=I... etc)

Column B contains certain value for each roman figure, and it defers (sometimes I can be 30 and other time 40... (B1= 30, B4= 40))

What i want in separate table is to add up all values for categories I, II, III, IV and V from the table above.

How can this be achieved by using a function (not filtering data)?

If I did not make myself clear, I will try and do it again... Not native English.

Thx