Results 1 to 3 of 3

Thread: Sum of category
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Nov 2005
    Posts
    264
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Sum of category

    Hi - I have 2 columns with 200 rows. Column A in cells numbers - column B in cells text being categories
    I require a formula to look at all cells and add up for each category

    There’s about 15 categories in the cells with repeats

    So example
    A. B
    1. 50. Red
    2. 20. Green
    3. 30. Red.

    Result I need. Red = 80

    Green = 20

  2. #2
    MrExcel MVP FormR's Avatar
    Join Date
    Aug 2011
    Location
    UK
    Posts
    6,111
    Post Thanks / Like
    Mentioned
    25 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Sum of category

    Hi, here is an option, or you could consider using a pivot table if you don't know the categories in advance.

    Excel 2013/2016
    ABCDE
    150RedRed80
    220GreenGreen20
    330Red

    Sheet1



    Worksheet Formulas
    CellFormula
    E1=SUMIFS(A:A,B:B,D1)

    [code]your code[/code]

  3. #3
    Board Regular
    Join Date
    Nov 2005
    Posts
    264
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Sum of category

    Thankyou

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
  •