DMCGETTIGAN
New Member
- Joined
- Oct 23, 2010
- Messages
- 23
...at least I think I should use SUMIF.
<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.
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.