• I have the data like this , I want to make total . please help me.

STYLE GOLDWT TYPE SIZE RATE WT
R-100 5.00 RD +2.2 250 0.25
RD +2.2 250 0.15
RD +2.3 260 0.11
TA 1.2m 100 0.15
TA 1.2m 100 0.25
MQ 2X2 400 0.50

I WANT THE SAME DATA MADE TOTAL ON TYPE, RATE , WT . HOW ?

THE ANSWER WILL BE LIKE THIS.i WANT TO USE FORMULA , NOT A VBA CODE.

STYLE GOLDWT TYPE SIZE RATE WT
R-100 5.00 RD +2.2 250 0.40
RD +2.3 260 0.11
TA 1.2m 100 0.40
MQ 2X2 400 0.50

TYPE AND RATE BASED TOTAL.

The reason I want formula is , I will change the rates so my output has to change the total based on rate and type.

If i change differnt rates , it has to change.

I will have like this more the 500 rows data typed .

I want to keep the data both so.

THANKS.

• Have you tried using a pivot table?

• I could be reading this wrong but,

Try =SumProduct((range=criteria)*(range=criteria))

• I think this is what you are seeking.

I have used an array formula

eg
={SUM(IF(\$G\$5:\$G\$11="RD",IF(\$L\$5:\$L\$11=200,\$H\$5:\$H\$11,0),0))}

I have copied sheet1 to sheet3 of your sample Workbook and inserted the array formulas in columns H and J

If you are interested I used the Conditional Sum Wizard to work out the formula.

Regards Insomniac

• No worries, glad to finally find a solution for you.

The sample you provided made it lot easier to work out what you wanted.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!