Excel 2007 : Some sort of IF and Count combination (assumption) help needed

[urke]

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

[Bob Phillips]

Use SUMIF

=SUMIF(A:A,"I",B:B)

etc.

[Domski]

You can do this either using SUMIF or a Pivot Table.

Dom

[arlu1201]

You can use sumif. First get the unique values of the roman numerals in one column. Say column C. Then put this formula in column D -

Please Login or Register  to view this content.

Drag down as required.

[urke]

No worries guys... Figured it out

by using sumif

Peace

[urke]

hahaha

many thx guys I posted this before I have seen your comments

appreciate your help