VLOOKUP: Percentage Breakdown

oilli

New Member
Joined
May 19, 2019
Messages
1
Hi guys,

I have a spreadsheet with multiple customers and price they paid for different items.
I am trying to find what percentage they spent on each items Can it be done with vlookup?

Here is an example:
NameItemPricePercentage Breakdown
Johnapple2
Tomapple3
Amyapple4
Johnbanana5
Tombanana6
Amybanana7

<tbody>
</tbody>

As you can see, John spent 2/7 of his money on apple and 5/7 on banana.

How can I do this with excel? What formula should I use?

Thank you in advance for support!
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Sanjeev1976

Board Regular
Joined
Dec 25, 2008
Messages
249
Hi,

Welcome to the forum. If your values are in row 2, you can use the below formula and then copy it to cells below :

=C2/SUMIF($A$2:$A$7,A2,$C$2:$C$7)
 

Watch MrExcel Video

Forum statistics

Threads
1,096,022
Messages
5,447,920
Members
405,472
Latest member
serhito

This Week's Hot Topics

Top