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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

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,305
Messages
5,449,570
Members
405,572
Latest member
Oberon

This Week's Hot Topics

Top