Thanx a lot Barb,

But I think you overlooked the column C showing rate for "sumproduct", or
rather I was unable to explain myself clearly. However, the following formula
worked out great:

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

Thanx again!

"Barb Reinhardt" wrote:

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