SUMIF Question...

[DMCGETTIGAN]

...at least I think I should use SUMIF.

10	A
20	B
30	C
15	A
25	B

<tbody>
</tbody>

I want to take Column A and add a percentage based on the what is in column B and place the total in C. IE A would equal to 10% B would equal 15% C would equal 5%.

I tried =SUMIF(A1:A5,"A",(A1*.1)) but am getting an error. Any assistance is great.

 

[DMCGETTIGAN]

Column I to be populated automatically based on what is in column B. The chart above is exactly what the finished product would look like.

 

[Aladin Akyurek]

Column I to be populated automatically based on what is in column B. The chart above is exactly what the finished product would look like.

Under which header are the expected results?

DATE

PRIORITY

EMP

SOR

CUST

PART #

COST

SO

%

FREIGHT

<tbody>


</tbody>

If under none, would you post them?

 

[DMCGETTIGAN]

%

 

[DMCGETTIGAN]

I just realized I could use vlookup....

I knew it was going to be a stupid solution...

Thanks for the help