Results 1 to 2 of 2

Thread: VLOOKUP: Percentage Breakdown
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Post VLOOKUP: Percentage Breakdown

    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:
    Name Item Price Percentage Breakdown
    John apple 2
    Tom apple 3
    Amy apple 4
    John banana 5
    Tom banana 6
    Amy banana 7

    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!

  2. #2
    Board Regular Sanjeev1976's Avatar
    Join Date
    Dec 2008
    Location
    Dubai
    Posts
    244
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: VLOOKUP: Percentage Breakdown

    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)

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •