Try something like this:

=SUMPRODUCT(--(RIGHT(A2:A10,LEN(A2:A10)-2)="I"),(B2:B10))



"FARAZ QURESHI" wrote:

Data is:
AMT RATE
A-I
A-II
A-III
B-I
B-II
B-III
C-I
C-II
C-III

I want to find out sumproduct of I, II and III of A B C separately, with a
single formula as:
Sales-I
Sales-II
Sales-III

Thanx!

FARAZ