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.
pLEASE REMAMBER I WANT TO USE FORMULAS? NOT WITH CODE. PLEASE.
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.